It will give you a compile error saying CURSOR WAS NOT DECLARED.

Hi Team,

Please tell me, If i don't declare the cursor in the program
and i have given open and fetch and close, then what error
will get.

Question Posted / rajiv

6 Answers
14118 Views
IBM, I also Faced
E-Mail Answers

Answer Posted / rajiv

It will give you a compile error saying CURSOR WAS NOT DECLARED.

Is This Answer Correct ?

11 Yes

0 No

Post New Answer View All Answers

Please Help Members By Posting Answers For Below Questions

How and when does the db2 enforces the unique key?

1079

Explain correlated sub-queries.

1025

what is a corelated subquerry?

1120

Mention the downsides of page level lock.

1159

What does runstats do in db2?

1099

What is the difference between "db2ilist" and "db2 get instance" commands in DB2 Database Server?

1267

What is a db2 package?

1045

What is the purpose of using commit?

1090

can any one provide me the link for the db2 v7 & db2 v8 manual for Z/os? i need to know about the syntax of REORG in both versions & need to know the difference as well

2232

What is the use of db2?

1047

What is cursor stability in db2?

1352

Explain about rct.

1083

How do I delete a column in db2?

1103

Mention the various locks that are available in db2.

1031

What is database alias db2?

1119