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
- 9065 Views
- iGate, I also Faced
- E-Mail Answers
Answer Posted / mandar panse
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 |
Post New Answer View All Answers
What is database alias db2?
What is dbrm? When it will be created?
Which are the db2 tools to protect integrity of the database?
What is copy pending status in db2?
What kind of database is db2?
run jcl for cobol+db2 pgm?.. //jobcard //step001 exec pgm=ikjeft01 //systin dd * DSNSYSTEM(--------) RUN PROGRAM(MYPGMNAME) PLAN(-----), LIB(-------), PARMS(------) /* WHAT WILL U GIVE INSIDE THE BRACKETS... WHAT IS PLAN,PACKAGE,BIND?..PLAN N PACAKGES ARE GENERATED BY ?...
What are the full forms of spufi and dclgen and why are they used?
Define predicate?
What is null indicator in cobol db2?
What are the rules for db2 programming?
How do we specify index to include or not during bind process.
What is runstats db2?
What do you mean by storage group (stogroup)?
Discuss about db2 bind?
What is db2? Explain.
