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
8908 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

How to execute stored procedure in db2 command editor?

1043

How to run db2 command in windows?

1183

What is view db2?

1061

i want to maintain uniqueness on pdf without make lf??????????

2151

Which component is responsible for db2 startup and shutdown?

1031

What does db2 mean?

1003

What is runstats and reorg in db2?

1293

Mention data types used in db2 ?

1150

How do I copy a table in db2?

994

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 ?...

4295

Define buffer pool.

1041

What are the 2 sqlcodes that are returned?

1181

What is release/acquire in bind?

1100

What is node in db2?

1037

What is innodb buffer pool?

1045