When is the skeleton cursor table created?
Answer / s
Skeleton cursor table is created when a new plan is bound.
Is This Answer Correct ? | 3 Yes | 0 No |
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 can we define a table? How can we apply SEARCH ALL on it ?
What is clone table?
what is commit & rollback? When and where is used while compiling a cobol-db2 program?
What is a correlated sub query?
How to resolve SQL Code -310. The db table feild is declared as Decimal(7,2).
How to update more then one record using update?
I have a subprogram B calling from mainprogram A.I have opened a cursor in A ,Can i fetch the same cursor in subprogram B , If yes , Please explain the reason?
I understand Join always perform better than subqueries. Then what is the advantage/use of Subqueries/correlated subqueries etc.,in DB2 programming.Please explain.
What happens in bind step in a db2 program?
What is the purpose of the WHENEVER statement?
What is coalesce in db2?