1. Categories >> Software >> MainFrame >> IBM MainFrame >> DB2
  2. Suggest New Category

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 / chandanavenkatesh

Answers were Sorted based on User's Feedback



Hi Team, Please tell me, If i don't declare the cursor in the program and i have given open..

Answer / rajiv

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

Is This Answer Correct ?    11 Yes 0 No

Hi Team, Please tell me, If i don't declare the cursor in the program and i have given open..

Answer / balaji

-504

Is This Answer Correct ?    4 Yes 0 No

Hi Team, Please tell me, If i don't declare the cursor in the program and i have given open..

Answer / tj

-504 Cursor name not declared.

Is This Answer Correct ?    1 Yes 0 No

Hi Team, Please tell me, If i don't declare the cursor in the program and i have given open..

Answer / ramesh

Rather I say ,Specofically, It will be Identified at Pre
compilation of your COBOL - DB2 source code.

Is This Answer Correct ?    0 Yes 4 No

Hi Team, Please tell me, If i don't declare the cursor in the program and i have given open..

Answer / dharani

Db2 return code would be -504 since the cursor is not
declared.

-501 - cursor not opened
-502 - opening cursor which is already opened
-503 - update column not specified in cursor while
declaring the cursor for updating some of the columns in
the table.

Is This Answer Correct ?    0 Yes 4 No

Hi Team, Please tell me, If i don't declare the cursor in the program and i have given open..

Answer / mr 10

Sql code : 501 i guess

Is This Answer Correct ?    0 Yes 5 No

Post New Answer

More DB2 Interview Questions

What is cloudant database?

0 Answers  

what is a collection?

2 Answers  

What is buffrpool? Where we use it ?

2 Answers   Tesco,

What is the purpose of the DSNC transaction ?

1 Answers  

What is a db2 cursor?

0 Answers  




How can tablespace be moved to another dasd volume that is allocated for that tablespace?

0 Answers  

What db2 400?

0 Answers  

What happens to a cursor after a commit?

3 Answers  

What is runstats db2?

0 Answers  

What is the logical entity between plan and Package?

5 Answers  

How can deadlocks be resolved?

0 Answers  

How to find the maximum value in a column in the db2 database?

0 Answers  

For more DB2 Interview Questions Click Here
Categories