Where can you declare a cursor in a cobol-db2 program?
- 0 Answers
- 763 Views
- I also Faced
- E-Mail Answers
select distinct(empid),distinct(dept),name from EMP will the above query work?
What are the prerogatives?
What is cursor stability in db2?
What is lock escalation?
what is dynamic cursor?gives syntax for this?
How to design maps
In db2, how do you insert multiple rows in 1 query using a.) Cursors, b.) Normal query?? Give syntax for both.
What is db2 command?
what is SPUFI ?
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.
What are the three types of page locks that can be held?
What is cursor stability?
COBOL 
