Interested to Buy Any Domain ? << Click Here >> for more details...
how can u understand the end of the table ?
- 1 Answers
- 6645 Views
- TCS, I also Faced
- E-Mail Answers
Answer / amarnadh reddy
If we set SQLCODE=100 means end of the table.
EX: if sqlcode=100
Display end of the table
end-if.
| Is This Answer Correct ? | 9 Yes | 1 No |
what is consistency token
How can you validate Sql errors during cursor operation in db2 pgms and where do you code?
How can we define a table? How can we apply SEARCH ALL on it ?
What is Reorg Recovery? when will you run it?
What is index cardinality?
What is dbrm?
why we create view.
How do you select a row using indexes in db2?
What is dpf in db2?
Name some fields from SQLCA.
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.
How to find schema of a table in db2?
COBOL 
