what is the difference between declaring the cursor in WS
section and Procedure division?
- 1 Answers
- 7403 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 is cursor stability in db2?
What is sqlca?
how can u understand the end of the table ?
My cobol program(not having any sql statements) is calling another cobol program ( having sql statements), what is needed for compilation and run in jcls .
What if we fail to give values in columns declared as NOT NULL ?
What is the purpose of the QUIESE Utility?
How can you validate Sql errors during cursor operation in db2 pgms and where do you code?
In cobol+DB2program if the code of cobol program has changed than i have to do precompilation once again?
what is the total syntax for fetch ? can any one please give me all the details of fetch ? thx
What is an EXPLAIN in DB2. How and what is the steps followed in EXPLAIN command. Can all the queries be used in EXPLAIN command to check the performance.
What are the different methods of accessing db2 from tso? How is the connection established between TSO & DB2?
In cursor program-1 can we create another cursor program-2 inside the cursor program-1.If yes how/no why ?
COBOL 
