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 |
Define sqlca.
What is meant by explain?
what are extents?
What is the COBOL picture clause of the following DB2 data types: DATE, TIME, TIMESTAMP?
What is normalization and what are the five normal forms?
Can we delete records from view?
how can u nderstand the sql stmts executed successfully or not ?
How do I optimize a query in db2?
when does the SQL statement gets executed when you use cursor in the application programming ?
How do you do the EXPLAIN of a dynamic SQL statement?
What is rebind in db2?
What is db2 catalog database?