Comment whether the cursor is closed during commit or not.
No Answer is Posted For this Question
Be the First to Post Answer
Mention the location where the output received from explain statement is stored.
i have a db2 variable how do u declare tht into working storage section ?
Can any one tell me about Restart logic in DB2.
What is db2 optimizer?
What is a Cartesian product?
What does it mean if the null indicator has -1, 0, -2?
Consider that a package is bound into 2 different collections and the PKLIST option specifies both the collections. If the collection id is not specified in the program while executing the SQL query, then when the DB2 system will search the package list, which collection will it pick up or will it give an error/abend?
Is it possible to create an Instance in DB2 using DB2 Control Center ?
Is Cursor exicutable ?
What are the advantages of using a PACKAGE?
What is meant by isolation level?
What do you mean by between and in? Is between inclusive of specified range values?