How to define the data items to receive the fetch items for
the SQL?
- 2 Answers
- 5177 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 |
If we keep the DCLGEN structure for a table in a copybook and include it in the COBOL program using the COPY statement, will there be any impact during compilation or at any stage of program execution?
What is the connection string to connect to the DB2 Database ?
When do you specify the isolation level?
Update command
What is the picture clause of the null indicator variable?
Mention the location where the output received from explain statement is stored.
What is a system catalog table in db2?
What is load utility in db2?
How can you find out which query is taking lot of time to execute in cobol-db2 program ?
What is dbrm library?
what is consistency token
What are delete-connected tables?
COBOL 
