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 |
What is Declaration Generator(DCLGEN)?
AGGREGATE function support by DB2. A) SUM & AVG B) SUM, MIN & AVG C) SUM, MAX, AVG , MIN &COUNT D) NONE
How to check table size in db2 sap?
Mention the different locking levels that are available in db2.
What are db2 tables?
What are some SQL aggregates and other built-in functions?
In a DB2-CICS program which is acts as co-ordinator and which is participant?
ther r 2 tables OTTABLE & SALTABLE, add the otamt from OTTABLE to empsal of SALTABLE if eid is matched else add the unmatched from OTTABLE to SALTABLE
What is the purpose of the QUIESE Utility?
what is sql abend code -801,-802?
What information can you find in SYSIBM.SYSLINKS table?
Hi Team, Please tell me, If i don't declare the cursor in the program and i have given open and fetch and close, then what error will get.