home
***
CD-ROM
|
disk
|
FTP
|
other
***
search
/
OS/2 Shareware BBS: 35 Internet
/
35-Internet.zip
/
wsa5labs.zip
/
loadBankDataBase.bat
< prev
next >
Wrap
DOS Batch File
|
2002-08-20
|
2KB
|
60 lines
@echo off
rem parameters are: 1=db2 userid, 2=db2 password, 3=Table.ddl file
db2 terminate
cls
echo.
echo ****************************************************************
echo ***************************** ********************************
echo *************************** ******************************
echo ************************* ****************************
echo *********************** **************************
echo ********************* ************************
echo ******************* **********************
echo.
echo About to drop the tables ACCOUNT and CUSTOMER
echo in the database called BankData!
echo.
echo Hit Ctrl-C now to abort this action
echo if you do not wish this to happen.
echo.
echo ******************* **********************
echo ********************* ************************
echo *********************** **************************
echo ************************* ****************************
echo *************************** ******************************
echo ***************************** ********************************
echo ****************************************************************
rem pause
db2 create database BankData
db2 connect to BankData user %1 using %2
db2 drop table Account
db2 drop table Customer
db2 update db cfg for BankData using applheapsz 2048
db2 update db cfg for BankData using logfilsiz 8192
db2 terminate
db2 connect to BankData user %1 using %2
db2 -tvf %3
%DB2INSTALLDRIVE%
cd %DB2INSTALLDIRECTORY%\bnd
db2 bind @db2cli.lst blocking all grant public
db2 connect reset
db2 terminate
title Command Prompt