Interested to Buy Any Domain ? << Click Here >> for more details...
how can u nderstand the sql stmts executed successfully or not ?
- 1 Answers
- 6069 Views
- TCS, I also Faced
- E-Mail Answers
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 |
What happens to the PLAN if index used by it is dropped?
In a DB2-CICS program which is acts as co-ordinator and which is participant?
Mention the downsides of page level lock.
What is COPY PENDING status?
what are the frequent DB2 abends did you encounter in your programs ?? What are different SQL abends ??
For unmatched rows returned from an outer join, the column values in the other table are set to null e.g If A OUTER JOIN B returns some unmatched rows from A, the corresponding column values in B will be set to null. What can be done so that a null value is not displayed for these columns?
In terms of DB2 indexing, what is the root page?
how 2 resolve the -311 sqlcode
Which catalog tables contain authorization information?
What is deadlock?
How do you find the maximum value in a column in db2?
What if we fail to give values in columns declared as NOT NULL ?
COBOL 
