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.
- 2 Answers
- 8134 Views
- iGate, I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Before opening this cursor thru OPEN <cursor_name>. because
when we open the cursor, it fetches all matching records
from table and stores them in buffer. so it evaluates that
where clause while opening the cursor.
| Is This Answer Correct ? | 8 Yes | 1 No |
Answer / nagendra
before open cursor we can populate that value
ex move 1220 to adb-dept
| Is This Answer Correct ? | 2 Yes | 1 No |
Return code 100 means?
In which column of which DB2 catalog would you find the length of the rows for all tables?
What is dbrm?
what is SMP/E? and what are the major steps of it? thanks...
how many partitions are possible in partitioned tablespace? dont say 1-64. a)240 b)256 c)512 d)none
in column y record abc.v abc.s xyz.j abc.h i wan only abc columns how to retrieve thi records
In an sql table that is embedded, what is the procedure to retrieve rows that are part of a db2 table?
How do you simulate the explain of an embedded sql statement in spufi/qmf?
What is a db2 collection?
what is the use of cursors?
What are the four lockable units for DB2?
What is db2 isolation?
COBOL 
