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 |
Usually, which is more important for DB2 system performance - CPU processing or I/O access?
Explain package in db2 and its advantages?
What DB2 Catalog column tell you when an index needs table reorganized ?
What is the error code -803 ?
define clustering index.
Why do chiropractors use drop table?
For Read Stability locks are not applicable for phantoms, What is Phantoms?
Why do we need to create an alias if we can directly use the table name? What are the benefits of referring a table name by its alias? Also, when should we go for alias and when for synonyms?
What language is db2 written in?
Which component is used to execute the sql statements?
How will you delete duplicate records from a table?
What is the role of schema in the db2 database?