Example: EXEC SQL FETCH AA

How to define the data items to receive the fetch items for
the SQL?

Question Posted / mehdee

2 Answers
5806 Views
I also Faced
E-Mail Answers

Answer Posted / 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

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

How can you classify the locks in db2?

1031

How do you find the maximum value in a column in db2?

1052

Name the lockable units in DB2?

1072

What is consistency token in db2?

1060

What is reorg and runstats in db2?

1142

Is it possible to alter a table – for example adding a column, when another user is accessing or updating some columns?

1029

Can we delete records from view?

914

How do I delete a table in database?

974

What is release/acquire in bind?

1054

What is null indicator in cobol db2?

991

What is the advantage in De-normalizing tables in DB2?

1110

Define declaration generator (dclgen).

1066

Why db2 is called db2?

969

What is the difference between db2 and oracle?

1067

Is db2 a mainframe database?

942