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
- 8173 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
If anyone has IBM Certification Dumps pls forward to me & also let me know what are the Certification Codes that are available in DB2
What is cloudant database?
What are bind parameters in db2?
How to resolve deadlock issue
What is commit in db2?
What is clone table?
What do you mean by rollback?
What is a system catalog table in db2?
What is the usage of open cursor command?
What are the two types of logging in the db2 database? Explain them.
What are the prerogatives?
What is view db2?
Mention the downsides of page level lock.
What is netezza database?
What is a db2 schema?
