Example: EXEC SQL FETCH AA

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

Question Posted / mehdee

2 Answers
5936 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

What is the difference between bind and rebind in db2?

1453

What is db2 plan table?

1050

What is check constraint. Explain with example.

1109

What os does db2 run on?

986

What is meant by union and union all?

1012

What is the physical storage length of date data type?

1254

Is ibm db2 free?

1013

What is buffer pool?

1107

Is it possible to create an Instance in DB2 using DB2 Control Center ?

1104

How to restart a DB2 program?

1902

How can you count the number of rows from a table tab?

1091

Name the lockable units in DB2?

1128

What are bind parameters in db2?

1047

What is catalog database in db2?

1165

For a db2 column that is being defined as decimal (11, 2), discuss the cobol picture clause.

1107