Cursors can be declared in both working-storage & procedure
division, Agreed.
But is there any difference? If could you please suggest
what is the difference.
TIA
Answer Posted / sathish
This can be declared in both the sections. But not sure
what is the diff.
Is This Answer Correct ? | 8 Yes | 5 No |
Post New Answer View All Answers
How to retrieve rows from a db2 table in embedded sql?
What is the difference between cursor stability and repeatable read isolation levels?
Name the lockable units in DB2?
What is coalesce in db2?
What is the difference between oracle and db2?
If I have a view which is a join of two or more tables, can this view be updateable?
What does runstats do in db2?
Which component is responsible for processing sql statements and selecting access paths?
Hi Everyone... Under the Logical files, when am working on multiple rec format logical file, I have joined two pf's using the multiple record format logical file concept, but when i run queried the LF only the first mentioned pf records are reflecting and I am not able to see any of the field records specified under the second pf. Kindly let me know whats the reason behind this. Below is the str of LF., R rec PFILE(LOGICAA) CUSTNO CUSTNAME BILL K CUSTNO R rec1 PFILE(LOGICAA1) CUSTNO ADD K CUSTNO .....
What is the physical storage length of timestamp data type?
What is drop table?
Is the primary key a clustered index?
What is the advantage in De-normalizing tables in DB2?
Explain dclgen.
What is the difference between cursor and select statement?