how can u nderstand the sql stmts executed successfully or not ?
Answer Posted / 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 View All Answers
What is the maximum number of columns in a db2 table?
How does coalesce work?
is it compulsory commitment control in journal?
List some fields from sqlca?
What is explain in db2?
How does db2 sample database connect?
Is db2 a mainframe?
How can the duplicate values be eliminated from db2 select?
Which component is responsible for processing sql statements and selecting access paths?
Hello All, We have requirment to Replace BMC Db2 Load product thru CA FAST LOADPlus product. Do anyone have JCL to for FAST LOADPLUS and what all are thing need to take in consideration.
File not opened because library is *PROD and debug is UPDPROD(*NO). ? what may be the reason? how to solve it..?
Explain correlated sub-queries.
What is db2 connect?
What happens in bind step in a db2 program?
How is deadlock resolved?