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
- 5811 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 |
What is DB2 (IBM Database 2)?
I need to view the number of tables existing under one particular Owner. Is it possible? If so, pl give the SQL query for this?
Can we declare DB2 HOST variable in COBOL COPY book?
How to know the primary key of a table without defining the primary key in the table?
What is a DB2 bind?
How do I delete a column in db2?
Where could you look if you had a question about whether a column has been defined as an index?
What is cascading rollback?
how to fetch first 100 rows in db2
How can you find out which query is taking lot of time to execute in cobol-db2 program ?
What's the maximum number of volumes that can be added to a STOGROUP?
List down the types of triggers in the db2 database?
COBOL 
