By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
438,756 Members | 1,760 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 438,756 IT Pros & Developers. It's quick & easy.

plz help me out

P: n/a
i have sript which will create the database
when i ran it through db2cmd it gives me an error like below:

DB21034E The command was processed as an SQL statement because it was
not a valid Command Line Processor command. During SQL processing it
returned:
04/07/2006 18:39:51 SQL1024N A database connection does not exist.
SQLSTATE=08003

what is the problem plz help me out.

Apr 7 '06 #1
Share this Question
Share on Google+
5 Replies


P: n/a
situ wrote:
i have sript which will create the database
when i ran it through db2cmd it gives me an error like below:

DB21034E The command was processed as an SQL statement because it was
not a valid Command Line Processor command. During SQL processing it
returned:
04/07/2006 18:39:51 SQL1024N A database connection does not exist.
SQLSTATE=08003


You don't have a connect to any database. So you should issue a CONNECT TO
<dbname> first.

--
Knut Stolze
DB2 Information Integration Development
IBM Germany
Apr 7 '06 #2

P: n/a
mine is database creation script, when i tried to connect to other
database in a instance through db2cmd its connecting , but still it
giving the same error when i ran my script

Apr 7 '06 #3

P: n/a
situ wrote:
mine is database creation script, when i tried to connect to other
database in a instance through db2cmd its connecting , but still it
giving the same error when i ran my script


Then you have a syntax error in your script because your command is not
interpreted as a DB2 command. So the CLP tries to give it to the DBMS for
parsing and execution, but you don't have a connection. Hence, it fails.

--
Knut Stolze
DB2 Information Integration Development
IBM Germany
Apr 7 '06 #4

P: n/a
If you are trying to create a new database the first two rows of the script
must are:

CREATE DATABASE xxxxxxx
CONNECT TO DATABASE xxxxxxx USER yyyyyyy USING zzzzzzz

Try it out.
"Knut Stolze" <st****@de.ibm.com> ha scritto nel messaggio
news:e1**********@lc03.rz.uni-jena.de...
situ wrote:
mine is database creation script, when i tried to connect to other
database in a instance through db2cmd its connecting , but still it
giving the same error when i ran my script


Then you have a syntax error in your script because your command is not
interpreted as a DB2 command. So the CLP tries to give it to the DBMS for
parsing and execution, but you don't have a connection. Hence, it fails.

--
Knut Stolze
DB2 Information Integration Development
IBM Germany

Apr 7 '06 #5

P: n/a
since its a weekend i didn't respond, thank u very much its working
fine now

Apr 10 '06 #6

This discussion thread is closed

Replies have been disabled for this discussion.