File not opened because library is *PROD and debug is
UPDPROD(*NO). ? what may be the reason? how to solve it..?
Is it Possible to read from PS file and write it to database by using dynamic sql(execute immediate)
what types of copies can be made with the COPY Utility ?
I have a table(product),It contain fields(productname,cost). I want to retrieve the product name ,which cost is second maximum in the table?
What is copy book?
How many types of page locks can be held in db2?
what's the error code for Unique Index Violation?
How to check table size in db2 sap?
What are the isolation levels possible ?
query to just fetch first matching row and stop execution. once one matching row is found ..no more records should be checked.. if the first record is matching.. the query must stop
What is correlation names?
What are the rules for db2 programming?
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?