Exec SQL Fetch<cursorname> into :<host variables> End-e

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

Question Posted / pandu

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

Answer Posted / pandu

Exec SQL
Fetch<cursorname> into :<host variables>
End-exec.

correct me is am wrong?

Is This Answer Correct ?

11 Yes

0 No

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

On which levels locks can be applied?

1130

Define buffer pool.

1053

How to find schema of a table in db2?

1016

What are the 2 sqlcodes that are returned?

1189

How do you pull up a query which was previously saved in qmf?

1149

List down the data types in the db2 database.

1123

How to execute stored procedures?

1130

What does a deadlock mean in DB2?

1167

Who uses db2?

1044

What is an instance in db2?

1033

What do you mean by between and in? Is between inclusive of specified range values?

1092

What is the purpose of using commit?

1098

What is scrollable cursor in db2?

1055

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

1166

I understand Join always perform better than subqueries. Then what is the advantage/use of Subqueries/correlated subqueries etc.,in DB2 programming.Please explain.

2065