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 different three logs in DB2?

1 Answers   Syntel,

What is a root page?

1 Answers  

What are the bind parameters ibm db2?

0 Answers  

Explain what a plan is?

3 Answers   CTS,

How to resolve deadlock issue

5 Answers   IBM,




How is the SUBSTR keyword used in sql?

1 Answers  

I HAVE 500 ROW TO UPDATE I WOULD LIKE TO USE ROLLBACK ALONG WITH COMMIT.WHAT IS THE SYNTAX TO CODE COMMIT AND ROLLBACK FOR EVERY 100 ROWS.AND HOW THE CURSOR ROLLBACK TO THE LAST COMMITTING POINT.

0 Answers   ITC Infotech, Syntel,

What is db2 connect?

0 Answers  

What should be specified along with a cursor in order to continue updating process after commit?

1 Answers   IBM,

What is meant by isolation level?

3 Answers  

What is the use of with ur in db2?

0 Answers  

How does DB2 use multiple table indexes?

1 Answers  

For more DB2 Interview Questions Click Here
Categories