What should be specified along with a cursor in order to
continue updating process after commit?
Mention the length of physical storage of the given data types of db2 – date, timestamp, time
Define db2 and its databases?
How to execute stored procedures?
What should be specified along with a cursor in order to continue updating process after commit?
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 is null indicator in db2?
Explain about cursor stability?
what is the difference between join and union?
How to access db2 tables in mainframe?
What does DML stand for and what are some examples of it?
How to design maps
How could one combine a set of incremental image copies into a single copy?