Interested to Buy Any Domain ? << Click Here >> for more details...
how can u nderstand the sql stmts executed successfully or not ?
- 1 Answers
- 5883 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 is db2 stogroup?
what is the use of bind parameter, Replace?
Why do we need reorg in db2?
What is phantom read in db2?
Is it possible to precompile if db2 goes down?
What is the role of the data page in the db2 database?
In cursor program-1 can we create another cursor program-2 inside the cursor program-1.If yes how/no why ?
in the CURSOR declare statement, if i am using an where clause and trying to compare the value with a host-varialble. EXEC SQL DECLARE C1 CURSOR FOR SELECT DEPTNO, DEPTNAME, MGRNO FROM DEPARTMENT WHERE ADMRDEPT = :ADM-DEPT Where would i need to provide value to this host-variable in the where clause. how could i pass value to this host-variable to check it.
what is the total syntax for fetch ? can any one please give me all the details of fetch ? thx
How can deadlocks be resolved?
How we create a tables in db2,what is the process/syntax to create a table with example plz?
What is db2 bind process?
COBOL 
