Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
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.

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

Give a brief description of db2 isolation levels?

1076


What is bind plan?

1056


How to fetch the last row from the table in SQL (db2)?

1658


How to find the maximum value in a column in the db2 database?

1084


What does db2 blu stand for?

1171


When reorg is used?

1137


How do you concatenate the firstname and lastname from emp table to give a complete name?

1077


What is the difference between plan and package in db2?

1124


How to check sequence on a table in db2?

1068


What is plan in cobol db2?

1144


What are host variables in db2?

1076


What is explain in db2?

1036


What is db2 stogroup?

1167


What is access path in db2?

990


What is package in cobol db2?

1121