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

can any body explain about plan and pakage in detail....

2 Answers   HSBC, IBM,


What is netezza database?

0 Answers  


If we keep the DCLGEN structure for a table in a copybook and include it in the COBOL program using the COPY statement, will there be any impact during compilation or at any stage of program execution?

2 Answers  


What value the host varible will contain , if null indicator value is -2 ? Will it contain the truncated value or nothing will move ?

3 Answers   Cap Gemini,


what is the maximum number of tables that can be joined ?

8 Answers   IBM, TCS,






What is db2 catalog database?

0 Answers  


What error I will get if my select query gives multiple row while executing a Cobol-DB2 program.How can I solve it without using a cursor.

4 Answers   Cap Gemini, Verizon,


what is different three logs in DB2?

1 Answers   Syntel,


In which column of which DB2 catalog would you find the length of the rows for all tables?

2 Answers  


What os does db2 run on?

0 Answers  


What is the syntax required for the creation of a cursor?

1 Answers  


File not opened because library is *PROD and debug is UPDPROD(*NO). ? what may be the reason? how to solve it..?

0 Answers   Infosys,


Categories