Sign Up Login


  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 types of copies can be made with the COPY Utility ?

1 Answers  

Mention the location where the output received from explain statement is stored.

0 Answers  

why we go for SPUFI for creating tables or for sql queries?

4 Answers  

What is host variable in db2 cobol?

0 Answers  

How do you declare a host variable (in COBOL) for an attribute named emp-name of type VARCHAR(25) ?

2 Answers   IBM, Tech Mahindra,

Explain an outer join?

1 Answers  

How do you concatenate the firstname and lastname from emp table to give a complete name?

0 Answers  

what is load and unload in db2

1 Answers   IBM,

What is ACQUIRE/RELEASE in BIND?

3 Answers   Cognizant,

what is the responsibility of the construction superintendent

0 Answers   Almco,

What is consistency token in db2?

0 Answers  

What are the disadvantages of using VARCHAR?

3 Answers  

For more DB2 Interview Questions Click Here
Categories