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

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

Question Posted / guest

2 Answers
6010 Views
I also Faced
E-Mail Answers

Answers were Sorted based on User's Feedback

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

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

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

Answer / sadiq afroze

Using the DSECT, followed by lines of - 'data items DS
datatype'.

Is This Answer Correct ?

0 Yes

2 No

Post New Answer

More DB2 Interview Questions

how to execute qcmdexc in rpgle?plz write code also?

1 Answers IBM,

What is correlated subquery?

1 Answers

Say CUST Table contains records like: CUSTNO CUSTNAME CUSTLOC 100 ABC SSS 200 XYZ 300 PQR 400 MNO WWW 500 CVV ------------- ------------- Now write a query to retrieve all records with CUSTLOC no data.

3 Answers IBM,

What's the maximum number of characters that a tablename can have?

3 Answers

what is rebinding ?

1 Answers IBM,

What is error -818 in db2. where can you find the timestamp of the DBRM and the source code.( precompile puts the timestamp on dbrm and source code correct?)

2 Answers

what is the difference between join and union?

4 Answers IBM,

Can you Average the Characters ?

3 Answers

How to execute stored procedure in db2 command editor?

0 Answers

There is a 5000 EMP in company.how we find out the 5th highest getting salary employee outof 5000 employes........

10 Answers IBM,

which SQL comment successfully removes uncommitted changes from a DB2 database A) rollback B) delete C) drop D) decommit

2 Answers Accenture, Wipro,

What is a thread?

3 Answers

For more DB2 Interview Questions Click Here