Thankyou Joachim & Abhijit. Both of your advice solves my problem either
way, thats really wonderful !!!!!!
Another basic problem
We are running on Windows NT and UDB 7.1 EE
Due to some reason CLP invocation fails with following error
"DB21061E Command line environment not initialized"
This happens during all these cases of invocation
1. dbcmd.exe
2. Programs -- <DB2 folder> ---> Command line processaor/command window
3. by typing "db2" from xx/sqllib/bin>
any ideas ????
Cheers
Bala
----- Original Message -----
From: "Sinha, Abhijit" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Wednesday, October 10, 2001 12:37 AM
Subject: RE: DB2EUG: a basic problem with UDB 7.1 command center
> 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
>
=====
To unsubscribe, send 'unsubscribe' to [EMAIL PROTECTED]
For other info (and scripts), see http://people.mn.mediaone.net/scottrmcleod
