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
- 9061 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
What are the rules for db2 programming?
On which levels locks can be applied?
How is the value function used?
What is db2 instance?
How many types of page locks can be held in db2?
What is meant by union and union all?
List down the types of triggers in the db2 database?
What is the syntax for seeing the columns and data types of a table in the db2 database?
Define db2.
How do you concatenate the firstname and lastname from emp table to give a complete name?
What is package in cobol db2?
How can we read records for specific member in CL? AND rpg?
What is db2 look?
How to check sequence on a table in db2?
what is diffrence b/w file-aid tool and file-aid utility???
