Using DB2 command line

rkalani · #1 (**permalink**) 02-20-04, 19:22

Hi,

I was running db2 commands by using the clp options

for eg :'db2 -tf xyz.clp'

and in the .clp file i had a call to a procedure. Now in db2 v8 the same thing is erroring out saying

SQL0084N An EXECUTE IMMEDIATE statement contains a SELECT or VALUES
statement. SQLSTATE=42612

Could you please tell what am i doing wrong here?

Thanks,
Rajesh

sathyaram_s · #2 (**permalink**) 02-20-04, 19:24

Can you post the xyz.clp file please ?

Cheers
Sathyaram

Quote:

Originally posted by rkalani
Hi,

I was running db2 commands by using the clp options

for eg :'db2 -tf xyz.clp'

and in the .clp file i had a call to a procedure. Now in db2 v8 the same thing is erroring out saying

SQL0084N An EXECUTE IMMEDIATE statement contains a SELECT or VALUES
statement. SQLSTATE=42612

Could you please tell what am i doing wrong here?

Thanks,
Rajesh

rkalani · #3 (**permalink**) 02-21-04, 15:45

connect to {DB} user {userid} using {password};
call SYSPROC.DSNWZP(?);
terminate;

sathyaram_s · #4 (**permalink**) 02-21-04, 16:09

I assume you are trying to use DB2 Connect V8 to connect to DB2 V7(or lower) on Z/OS ?

Have you checked the compatability of this version of Connect V8 to the database server ?

You can try using CLI Trace to know what request is being sent to the server

Cheers
Sathyaram

Quote:

Originally posted by rkalani
connect to {DB} user {userid} using {password};
call SYSPROC.DSNWZP(?);
terminate;

rkalani · #5 (**permalink**) 02-23-04, 14:22

Sathyaram,

I checked and indeed that is the problem. Thanks for the useful comment.

Could you tell me what rang the bell that you said that I might be using the v8 clinet to point to a v7 server?

Thanks,
Rajesh