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

List down the types of triggers in the db2 database?

1079

What is the meaning concurrency in the db2 database?

1170

What is catalog database in db2?

1218

What kind of database is db2?

1087

Explain correlated sub-queries.

1096

What are the contents of dclgen?

1165

How can you find out the # of rows updated after an update statement?

1154

What is explain plan in db2?

1052

What is reorg and runstats in db2?

1262

What is the reason behind not using select * in embedded sql programs?

1174

What is buffer pool?

1160

What does db2 plan contain?

1090

Mention the definition of cobol in varchar field.

1315

What is release/acquire in bind?

1164

Which command is used to remove all rows from a table?

1183