Be sure to include sqlca in working storage section. Then you can check sq

where will u check for sqlcode ?

Question Posted / shaan

Answer Posted / shaan

Be sure to include sqlca in working storage section.
Then you can check sqlcode from the copybook variable SQLCODE.

Is This Answer Correct ?

15 Yes

0 No

Please Help Members By Posting Answers For Below Questions

Explain the contents that are a part of dclgen.

1038

What action db2 takes when a program aborts in the middle of a transaction?

1092

Hi, i would like to start a new carrier in DB2 DBA.Which and what all step should i have to take..?

3090

What is a collection in db2?

985

How can you validate Sql errors during cursor operation in db2 pgms and where do you code?

2170

What are sqlcodes –803,-805, -811, -818,-904,-911,-913,-101, +100?

1114

What are db2 objects?

1002

What is the purpose of rollback and commit?

1089

How can we retrieve the total number of records in RPG & CLLE?

580

What do you mean by cursor?

942

What are the full forms of spufi and dclgen and why are they used?

1024

is it compulsory commitment control in journal?

2419

How does db2 sample database connect?

975

What is image copy in db2?

946

How to access db2 tables in mainframe?

992