How to define the data items to receive the fetch items for
the SQL?
- 2 Answers
- 4945 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 the differences between spufi and qmf and which is better?
4 Answers Accenture, Cap Gemini,
What if , we failed to mentioed null indicator in sql select query , that may retrieve null value ?
What does the RUNSTATS Utility do?
What are data types?
What is UNION,UNION ALL?
How do you eliminate duplicate values in db2?
Consider that a package is bound into 2 different collections and the PKLIST option specifies both the collections. If the collection id is not specified in the program while executing the SQL query, then when the DB2 system will search the package list, which collection will it pick up or will it give an error/abend?
How to execute stored procedures?
Could anyone clearly explain the diference between sub query and correlated sub query?
Explain about open switch business continuity software?
When is the skeleton cursor table created?
How would the varchar column remarks defined?
COBOL 
