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
6397 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

How to check table size in db2 sap?

1038

What is syscat in db2?

1010

What are union and union all?

981

what is diffrence b/w file-aid tool and file-aid utility???

4890

What is role in db2?

1107

What is view db2?

1076

What are db2 tables?

1125

How to get the ddl of a table in db2?

1131

How would the varchar column remarks defined?

1088

What is the syntax for seeing the columns and data types of a table in the db2 database?

1166

What is netezza database?

1025

What does db2 blu stand for?

1165

Explain dclgen.

1199

Which component is responsible for db2 startup and shutdown?

1035

How to fetch the last row from the table in SQL (db2)?

1653