how can u nderstand the sql stmts executed successfully or not ?
- 1 Answers
- 5489 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 |
If a non-DB2 program calls a DB2 program, the calling program's name will be there in SYSIN of IKJEFT01 and the plan name will be that of the called program. But is a bind needed or a plan has to be created for the non-DB2 program also?
What is the self-referencing constraint?
What else is there in the PLAN apart from the access path?
in db2, already 10 columns arie der, and i want to insert 11th column. what parameters u wil consider for insertion and how will u insert
How many databases are there?
In a DB2-CICS program which is acts as co-ordinator and which is participant?
Which one allows duplicate values Union or Union All ?
max number of columns in a db2 table?
If I have 5 Queries in a DB2 Cobol program , while precompiling how many DBRMs will get created and How many Plans and Packages will get created while Bind Process?
Which transaction use a command thread ?
What is correlated subquery?
What is cursor?
COBOL 
