Interested to Buy Any Domain ? << Click Here >> for more details...
How to define the data items to receive the fetch items for
the SQL?
- 2 Answers
- 5943 Views
- I also Faced
- E-Mail Answers
Answers were Sorted based on User's Feedback
Answer / mehdee
Example:
EXEC SQL
FETCH AA_CURS
INTO :Host-name1, Host-name2, ...
EXEC-END
Note: Host-names listed are one to one related to the
Columns at DECLARE AA_CURS, and are INCLUDEed from it's
DB2 DECLGEN name in the program.
| Is This Answer Correct ? | 2 Yes | 0 No |
Answer / sadiq afroze
Using the DSECT, followed by lines of - 'data items DS
datatype'.
| Is This Answer Correct ? | 0 Yes | 2 No |
When a COBOL-DB2 program in PRODUCTION is updating main tables and gone for long run, what have to do?
What is query_cache_limit?
In cursor program perform para varying until 1 by 1 fetch para cursor------close para in the blank what will come for confirming in the database?
Explain package in db2 and its advantages?
what is dynamic cursor?gives syntax for this?
Request to database but database is not available so what is was abend is raised?
What is referential integrity?
Where can you declare a cursor in a cobol-db2 program?
In cursor program-1 can we create another cursor program-2 inside the cursor program-1.If yes how/no why ?
What is cursor stability?
What is the result of open cursor statement?
what is REORG? what is the use?
COBOL 
