468,257 Members | 1,410 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 468,257 developers. It's quick & easy.

plz help me out

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
5 1079
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
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
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
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
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.

Similar topics

3 posts views Thread by William C. White | last post: by
2 posts views Thread by Albert Ahtenberg | last post: by
3 posts views Thread by James | last post: by
reply views Thread by Ollivier Robert | last post: by
1 post views Thread by Richard Galli | last post: by
4 posts views Thread by Albert Ahtenberg | last post: by
1 post views Thread by inderjit S Gabrie | last post: by
2 posts views Thread by Jack | last post: by
3 posts views Thread by Sandwick | last post: by
reply views Thread by kermitthefrogpy | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.