What are the various locking levels available?
Answers were Sorted based on User's Feedback
Answer / ram
Cursor Stability, Read Stability, Uncommited Read and Repeatable Read
| Is This Answer Correct ? | 0 Yes | 2 No |
What is bufferpool in db2?
What is the database descriptor?
What if we try to insert the base table through updatable view , but failed to give a column value which is defined as NOT NULL.
What is temporal table in db2?
Once you create a view, where would information about the view be stored?
how do we solve soc 7 and soc4 ?
How can we read records for specific member in CL? AND rpg?
Hi i need to write a query on the following requirement. SELECT COMM_TEXT INTO :WS_MIKM_COMM_TEXT FROM MPIPROD.MIKMV01 WHERE ACCOUNT_NO = :WFD_ACCOUNT_NO AND (SUBSTR(COMM_TEXT,1,39) = :WS_COMMENT_TEXT AND SUBSTR(COMM_TEXT,47,14) = :WS_DENY_DESC) OR (SUBSTR(COMM_TEXT,1,39) = :WS_COMMENT_TEXT) The above query is to be modified. The requirement is if both the fields are equal then that has to be given priority. In the above query if it satisfies any one it comes out without checking if both being equal is possible.
What does the sqlcode of -818 pertain to?
How do you find the maximum value in a column in db2?
What is null indicator in cobol db2?
How to test SQL -911 error while developing COB-DB2 program