before open cursor we can populate that value ex move 1220 to adb-dept

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.

Question Posted / nagendra

2 Answers
8778 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

Please Help Members By Posting Answers For Below Questions

What is the function of logging in the db2 database?

1069

Explain the contents that are a part of dclgen.

1034

Define check constraint.

1025

How does a cursor work?

928

What is bind and rebind in db2?

1072

What is cursor stability in db2?

1276

On which levels locks can be applied?

1060

What is meant by explain?

1062

What is the difference between bind and rebind in db2?

1392

What is rebind in db2?

999

what is a corelated subquerry?

1063

What is concurrency?

1150

What is copy pending and check pending in db2?

950

What is a storage group (stogroup)?

1189

What are the various isolation levels possible?

1048