Interested to Buy Any Domain ? << Click Here >> for more details...
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
- 8953 Views
- iGate, I also Faced
- E-Mail Answers
Answer Posted / nagendra
before open cursor we can populate that value
ex move 1220 to adb-dept
| Is This Answer Correct ? | 2 Yes | 1 No |
Post New Answer View All Answers
Give a brief description of db2 isolation levels?
What is bind plan?
How to fetch the last row from the table in SQL (db2)?
How to find the maximum value in a column in the db2 database?
What does db2 blu stand for?
When reorg is used?
How do you concatenate the firstname and lastname from emp table to give a complete name?
What is the difference between plan and package in db2?
How to check sequence on a table in db2?
What is plan in cobol db2?
What are host variables in db2?
What is explain in db2?
What is db2 stogroup?
What is access path in db2?
What is package in cobol db2?
