How to define the data items to receive the fetch items for
the SQL?
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 consistency token
When do you specify the isolation level?
How can you find out which query is taking lot of time to execute in cobol-db2 program ?
what is copy pending and check pending ?
define clustering index.
What is cobol db2?
One program calling 5 subprograms, its a cobol db2 program, after precompilation how many plans and packages will created?
What is the difference between Where and Having Clause
Can you search give an array in the WHERE clause of a db2 query?
what is the use of bind parameter, Replace?
Define predicate?
How can you classify the locks in db2?