Bala,
I am assuming NT platform V7.1 FP3.
If you have a ".bat" file, you go open up : Programs --> <DB2 folder> -->
Command Window.
Here, go to the specified directory where the ".bat" file resides and
execute the ".bat" file just by typing in the file name.
The ".bat" file can contain your sql statements like:
db2 "connect to <database> user <user> using <pw>"
db2 "select * from user.table1"
db2 "select * from user.table2"
You do not need a separator if you start the command with "db2".
On the other hand, you can choose to have a text file (say
"mytextfile.txt"), which contains all your sql statements like:
connect to <database> user <user> using <pw>;
select * from user.table1;
select * from user.table2;
Here you MUST have a command separator.
Now you need to have a batch file (".bat") which will contain commands to
execute the sql in the "mytextfile.txt" file.
This ".bat" file can contain, for e.g. a command like,
db2 -tvf .\mytextfile.txt
Now, just execute the ".bat" file as outlined above. The ".txt" file option
is good if, say, your sql statements are generated from a database modelling
tool and you want to execute the entire list of sqls in one batch.
Hope this helps.
Abhijit
-----Original Message-----
From: Bala Rajagopal [mailto:[EMAIL PROTECTED]]
Sent: Tuesday, October 09, 2001 1:06 PM
To: [EMAIL PROTECTED]
Subject: Re: DB2EUG: a basic problem with UDB 7.1 command center
Hi Abijit,
Do you use -tf filename.bat from comman line ?
Did you try via script center, it is supposed to do the same what we do from
command line ?
Mean while i have posted one more problem that i face with executing wraped
stmts thru script center.
Thanks for you input though......
Bala
----- Original Message -----
From: "Sinha, Abhijit" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Tuesday, October 09, 2001 7:56 PM
Subject: RE: DB2EUG: a basic problem with UDB 7.1 command center
> Bala,
>
> I faced the same problem here. As an alternative, I put all the sql
> statements with separators in a batch (".bat" file) and execute the file
> from the DB2 Command Window.
>
> Abhijit
>
> -----Original Message-----
> From: Bala Rajagopal [mailto:[EMAIL PROTECTED]]
> Sent: Tuesday, October 09, 2001 8:42 AM
> To: [EMAIL PROTECTED]
> Subject: DB2EUG: a basic problem with UDB 7.1 command center
>
>
> Hi,
>
> I'm trying to configure UDB client. I'm unable to execute more than one
sql
> statement from my command center. If I seperate multiple stmts with
> semicolon, it stops after the first statement. What i can I do to avoid
this
> and execute multiple stmts separated by semicolon. I tried LIST COMMAND
> OPTIONS and UPDATE COMMAND OPTIONS but couldnt find a solution. Pleasee
> help.
>
> Bala
>
>
> =====
> To unsubscribe, send 'unsubscribe' to [EMAIL PROTECTED]
> For other info (and scripts), see
http://people.mn.mediaone.net/scottrmcleod
>
=====
To unsubscribe, send 'unsubscribe' to [EMAIL PROTECTED]
For other info (and scripts), see http://people.mn.mediaone.net/scottrmcleod
=====
To unsubscribe, send 'unsubscribe' to [EMAIL PROTECTED]
For other info (and scripts), see http://people.mn.mediaone.net/scottrmcleod
