Mention and explain the contention situations caused by locks?
What is PRIME TABLE and what are the uses of it
How to resolve -407 sql code in DB2?
How do I delete a table in database?
What information is contained in a SYSCOPY entry?
What is package in cobol db2?
What is a LIKE table and how is it created?
What is the purpose of the QUIESE Utility?
How do you prepare a COBOL + DB2 program from coading till execution ?
Update command
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?
In db2, how do you insert multiple rows in 1 query using a.) Cursors, b.) Normal query?? Give syntax for both.
Q4. How will you get the count of record without using COUNT verb in query?