where will u check for sqlcode ?

Answers were Sorted based on User's Feedback



where will u check for sqlcode ?..

Answer / 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

where will u check for sqlcode ?..

Answer / guru

If you dont include SQLCA, Define SQLCODE and SQLSTATE as
working storage variables and This will suffice

Is This Answer Correct ?    2 Yes 0 No

Post New Answer

More DB2 Interview Questions

How do I delete a table in db2?

1 Answers  


What are the different types of base tables?

1 Answers  


What is a cursor?

2 Answers  


How to resolve -805 error in DB2?

1 Answers   Cap Gemini,


what is the use of bind parameter, Replace?

5 Answers   IBM,


What does DSNDB07 database do?

2 Answers  


What happens to the PLAN if index used by it is dropped?

1 Answers  


Why do we bind in db2?

1 Answers  


What will happen, while trying to close the closed cursor.

1 Answers  


What is the meaning of -805 SQL return code?

3 Answers  


Which component is responsible for db2 startup and shutdown?

1 Answers  


Is db2 a mainframe database?

1 Answers  


Categories