YES THE ABOVE SYNTAX IS CORRECT IF THERE ARE MORE THAN ONE HOSTVARIABLES

what is the total syntax for fetch ? can any one please give
me all the details of fetch ? thx

Question Posted / sree

2 Answers
6285 Views
IBM, I also Faced
E-Mail Answers

Answer Posted / sree

YES THE ABOVE SYNTAX IS CORRECT

IF THERE ARE MORE THAN ONE HOSTVARIABLES,IE IF THERE ARE
MORE COLUMNS IN THE DB2 TABLE

SYNTAX IS

EXEC SQL
FETCH CURSORNAME INTO :HOSTVARIABLE1 ,
:HOSTVARIABLE2 ,
---
---
:HOSTVARIABLEN
END-EXEC

Is This Answer Correct ?

11 Yes

0 No

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

What are the contents of dclgen?

1054

How do I optimize a query in db2?

1042

How do you eliminate duplicate values in db2?

1110

How do I connect my db2 database to ibm?

988

How to find schema of a table in db2?

953

What is dclgen (declaration generator)?

1012

What is commit in db2?

998

What is the syntax for FETCH in DB2 ?

1141

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

1043

What is cascading rollback?

1135

define clustering index.

980

What are the uses of db2 optimizer?

1229

Explain correlated sub-queries.

979

Explain how can you do the explain of a dynamic sql statement?

1066

What is ibm db2 client?

883