DB2: A calls B once sucessfull and second time when it
calls says curson is open why is it so?
Answer / sunil
while declearing the cursor in working-storage
section 'with hold' option is used due that's why cursor
remains open while next processing
| Is This Answer Correct ? | 8 Yes | 0 No |
Can we declare DB2 HOST variable in COBOL COPY book?
Can SQL statements/queries be included in a copybook?
What is a page in db2?
What is the physical storage length of date data type?
how can u retrieve the data from null values using applicaion program.
how to resolve -811
Explain what a plan is?
What is buffer pool?
What is a PLAN table? How will you use it? Give the various fields of PLAN table?
Give a brief description of db2 isolation levels?
What are the 2 sqlcodes that are returned?
Can a unique index have more than one null value? If not, what error code is given if an attempt is made to insert more than one null value?