how can u understand the end of the table ?
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 a result table?
In case if at some point of time db2 is down, would that impact the pre-compilation process of a db2-cobol program?
What is the difference between plan and package in db2?
How do I add a column to an existing table in db2?
Hi Everyone... Under the Logical files, when am working on multiple rec format logical file, I have joined two pf's using the multiple record format logical file concept, but when i run queried the LF only the first mentioned pf records are reflecting and I am not able to see any of the field records specified under the second pf. Kindly let me know whats the reason behind this. Below is the str of LF., R rec PFILE(LOGICAA) CUSTNO CUSTNAME BILL K CUSTNO R rec1 PFILE(LOGICAA1) CUSTNO ADD K CUSTNO .....
What is the purpose of using commit?
If I have a view which is a join of two or more tables, can this view be updatable?
What is JOIN and different types of JOIN.
Explain various types of locks in db2?
How can you classify the locks in db2?
i want to delete 20th million record how ?
I need to view the number of tables existing under one particular Owner. Is it possible? If so, pl give the SQL query for this?