how can u nderstand the sql stmts executed successfully or not ?



how can u nderstand the sql stmts executed successfully or not ?..

Answer / lu

Oh man, you have to check SQLCODE for each SQL
stament...SQLCODE = 0 it's good.... SQLCODE not = 0 it's
bad.
OR you look in SQLCA... verify this SQLERRD

Is This Answer Correct ?    5 Yes 0 No

Post New Answer

More DB2 Interview Questions

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

0 Answers  


What is precompiler in db2?

0 Answers  


Comment whether the cursor is closed during commit or not.

0 Answers  


pls explain the precompilation process of cobol-db2 pgm

3 Answers   HCL, IBM,


What is the usage of open cursor command?

0 Answers  






How does one bind 2 versions of a CICS transaction with the same module name in two different CICS regions that share the same DB2 subsystem?

2 Answers  


How can record locking be achieved in those DB2 versions which do not support it?

0 Answers  


What is lock contention?

1 Answers  


Is Cursor exicutable ?

3 Answers   TetraSoft,


how do u update the faltfile into db2 table ?

4 Answers   RBS, TCS,


what is datacom db?

2 Answers   CSC,


What is index in db2?

1 Answers  


Categories