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
No Answer is Posted For this Question
Be the First to Post Answer
Can we insert update delete in view?
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
DB2 can implement a join in three ways using a merge join, a nested join or a hybrid join. Explain the differences?
How is a typical db2 batch pgm executed?
Give some example of statistics collected during RUNSTATS?
why should we bind the DB2 program . What if we did not BIND a BD2 program ??
9 Answers Infosys, TCS, Xansa,
Lot of updates have been done on a table due to which indexes have gone haywire. What do you do?
What are iseries servers?
List down the types of triggers in the db2 database?
What is db2 and what is the use of db2 optimizer?
When do you specify the isolation level? How?
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.