If the cursor is kept open followed the issuing of commit, what is the procedure to leave the cursor that way?
No Answer is Posted For this Question
Be the First to Post Answer
What are bind parameters in db2?
What is alias in db2?
Explain an outer join?
How to restart a DB2 program?
What is runstats and reorg in db2?
What action db2 takes when a program aborts in the middle of a transaction?
What is error -818 in db2. where can you find the timestamp of the DBRM and the source code.( precompile puts the timestamp on dbrm and source code correct?)
Define sqlca.
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 is the SQL Communications Area and what are some of its key fields?
Is ibm db2 free?