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
6385 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 do you find the maximum value in a column in db2?

1096

How does db2 sample database connect?

1024

What is a cursor in programming?

1061

What is the physical storage length of the data types date, time, and timestamp?

1084

What is db2?

1172

Why select is not preferred in embedded sql programs?

1296

Can we insert update delete in view?

961

How to run db2 command in windows?

1188

What action db2 takes when a program aborts in the middle of a transaction?

1144

Explain correlated sub-queries.

1025

How to check table size in db2 sap?

1032

is it compulsory commitment control in journal?

2474

What is the difference between nvl and coalesce?

1058

What is meant by union and union all?

1006

How do I change the column size in db2?

1151