Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...

  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

Mention and explain the contention situations caused by locks?

1 Answers  

can all users have the privilage to use the sql statement select * (dml)?

0 Answers   IBM,

How to know the primary key of a table without defining the primary key in the table?

5 Answers   Satyam,

How to define the a field which accepts value till 99999.99 in db2

3 Answers  

Is DECLARE TABLE in DCLGEN necessary? Why it used?

3 Answers  

While unloading huge amount of data from table. Suddenly job failed some error. Imagine 1M data unloading, In that 90% data unloaded only 10% left, So if want to unload the rest 10% what needs to be done? Whether do i need to start from top or anything ?

0 Answers   JPMorgan Chase,

in db2, already 10 columns arie der, and i want to insert 11th column. what parameters u wil consider for insertion and how will u insert

1 Answers   TCS,

Hi Everyone... Under the Logical files, when am working on multiple rec format logical file, I have joined two pf's using the multiple record format logical file concept, but when i run queried the LF only the first mentioned pf records are reflecting and I am not able to see any of the field records specified under the second pf. Kindly let me know whats the reason behind this. Below is the str of LF., R rec PFILE(LOGICAA) CUSTNO CUSTNAME BILL K CUSTNO R rec1 PFILE(LOGICAA1) CUSTNO ADD K CUSTNO .....

0 Answers  

What is a root page?

1 Answers  

Update command

1 Answers  

Mention a credible reason why select* is never given preference in an sql program that has been embedded.

0 Answers  

What is FREEPAGE and PCTFREE in TABLESPACE creation?

1 Answers  

For more DB2 Interview Questions Click Here
Categories