How i see the SQLCA contents after excution of program

sunil_chappy · Posted: Sat Apr 15, 2006 2:16 pm

HI,
In COBOL-DB2 program my SQL taking too much time.......please tell me how i know whts the reason for that and how i solve that problem.

2. How i see the SQLCA contents after excution of program.

Jag · New User Joined: 07 Dec 2005 Posts: 30 Location: India

Hi...

The main reason for taking much time for running query may be you have n't used the Indexes in the Where clause of the query.Or you query may really fetching more data...

Coming to next question..Are you using the query in the application program or SPUFI..If yo are using spufi you will get the SQLCODE and SQLSTATE and stuff of the execution irrespective of whether the query has been exexuted Sucessfully or nor..If you are using the query in the Application program then while handing the error you give the display statement for the SQLCA parameters which you can see in the output..

I hope i cleared your doubvt

r2k1984 · New User Joined: 21 Jun 2005 Posts: 69 Location: chennai

ur query is not a optimised query.when u are using a big database try to use sub queries or groupb and having cammands.

mann_naaz · New User Joined: 13 Dec 2006 Posts: 4 Location: Pune

I M GETTING SQLCODE AND SQLSTATE IN SPOOL BUT IN HEXADECIMAL FORMAT

HOW TO GET IN DECIMAL FORMAT

prav_06 · Posted: Wed Jan 10, 2007 2:22 pm

HI Mann_naaz tyhe PIC of sqlcode is comp-4 so if u print the same it would be in hex format try this one

01 ws-sqlerr pic -9(3).

Move sqlcode to ws-sqlerr.

Display ws-sqlerr

and reg SQLSTATE it is X95) in picture clause so u can display it directly

Cheer's,

Thamilzan.

mann_naaz · New User Joined: 13 Dec 2006 Posts: 4 Location: Pune

THANKZ THAMILZN
I HAVE APPLIED IT AND IT IS WORKING.

kgumraj · Posted: Thu Jan 11, 2007 7:12 pm

Hi,