Where besides the DB2 catalog is database object
information stored by DB2?
Answer / s
Datbase object information is stored in a internal format
in DBD, Database Descriptors.
| Is This Answer Correct ? | 2 Yes | 0 No |
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
There is a 5000 EMP in company.how we find out the 5th highest getting salary employee outof 5000 employes........
Mention the various locks that are available in db2.
What's the Maximum Length of SQLCA and what's the content of SQLCABC?
What are the contents of dclgen?
how to copy the host variables from ps file into cobol program other than include statement
What is dclgen (declaration generator)?
In db2, how do you insert multiple rows in 1 query using a.) Cursors, b.) Normal query?? Give syntax for both.
Is it possible to update a primary key value? If not, what is the error code given? If yes, can more than 1 primary key column be updated at a time?
How can you compare table column after update and before update?
Name some fields from SQLCA
How can you split a table in to exactly half?