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
- 8821 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
I HAVE 500 ROW TO UPDATE I WOULD LIKE TO USE ROLLBACK ALONG WITH COMMIT.WHAT IS THE SYNTAX TO CODE COMMIT AND ROLLBACK FOR EVERY 100 ROWS.AND HOW THE CURSOR ROLLBACK TO THE LAST COMMITTING POINT.
Explain the function of data manager.
Explain the contents that are a part of dclgen.
What is the purpose of rollback and commit?
What is cloudant database?
What do you mean by commit and rollback?
Give the name of some fields form sqlca.
How do I create a view in db2?
Define db2.
Hello All, We have requirment to Replace BMC Db2 Load product thru CA FAST LOADPlus product. Do anyone have JCL to for FAST LOADPLUS and what all are thing need to take in consideration.
What are the full forms of spufi and dclgen and why are they used?
What's The Percentage Free Space ?
What are the various isolation levels possible?
What is the default page size of buffer pools?
If anyone has IBM Certification Dumps pls forward to me & also let me know what are the Certification Codes that are available in DB2
