Example: EXEC SQL FETCH AA

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

Question Posted / mehdee

2 Answers
6008 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 difference between isnull and coalesce?

1104

What is a storage group (stogroup)?

1284

Which isolation level provides maximum concurrency?

1203

What is a db2 cursor?

1106

On which levels locks can be applied?

1200

How to get the ddl of a table in db2?

1168

What are catalog tables in db2?

1104

What is a db2 table?

1061

Explain in detail about buffer manager and its functionalities?

1135

What is the difference between dbm cfg and db cfg file in db2 ?

1589

in my project..TEST is db2 8.1 version In PROD it is 7.1 if i do REORG in TEST.. can I use the same REORG jcl with out modification in PROD region (this is DB2 8.1 )? if not, what modification i need to do in my REORG control card?

2155

What is a buffer in memory?

1107

Define db2.

1164

What is drop table?

1060

What is dbrm? What it contains? When it will be created?

1099