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

Post New Answer

More DB2 Interview Questions

Can we insert update delete in view?

0 Answers  


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

0 Answers  


DB2 can implement a join in three ways using a merge join, a nested join or a hybrid join. Explain the differences?

0 Answers  


How is a typical db2 batch pgm executed?

0 Answers  


Give some example of statistics collected during RUNSTATS?

1 Answers  






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?

2 Answers  


What are iseries servers?

0 Answers  


List down the types of triggers in the db2 database?

0 Answers  


What is db2 and what is the use of db2 optimizer?

0 Answers  


When do you specify the isolation level? How?

1 Answers  


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.

1 Answers  


Categories