Interested to Buy Any Domain ? << Click Here >> for more details...
what is the difference between declaring the cursor in WS
section and Procedure division?
- 1 Answers
- 8536 Views
- HCL, I also Faced
- E-Mail Answers
Answer / madhavi chava
As definition of cursor is non executable statement, it is
advisable not to define in procedure division as it may
misunderstood others.
we can define it any where only thing you have to take care
is definition of cursor should be prior to the OPEN
statement of the same cursor.
| Is This Answer Correct ? | 18 Yes | 1 No |
What does db2 blu stand for?
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 deadlock in db2?
List down the types of triggers in the db2 database?
Can we able to find all the Table names under a Particular Plan?
what is differnece between DROP TABLE & DELETE TABLE .
What are the benefits of using the db2 database?
What is the purpose of the QUIESE Utility?
Can one database have multiple instances?
What is db2 plan table?
How to select the duplicate rows from a table?
What happens to the PLAN if index used by it is dropped?
COBOL 
