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

For update of a row in cursors, when do we move value into
host variable in cobol progrm? is it before open or before
fetch ?

Question Posted / sudha2811

Answers were Sorted based on User's Feedback



For update of a row in cursors, when do we move value into host variable in cobol progrm? is it be..

Answer / azharuddinsyed

in Open, the sql query you have coded in declare cursor will be executed.
in Fetch, the table column values will be moved to corresponding host variables.

Is This Answer Correct ?    0 Yes 0 No

For update of a row in cursors, when do we move value into host variable in cobol progrm? is it be..

Answer / tarun

The query in a cursor in executed only when the cursor is opened. Thus you have to move the values in the host variables before opening the cursor.

Is This Answer Correct ?    8 Yes 17 No

Post New Answer

More DB2 Interview Questions

What does the CHECK Utility do ?

1 Answers  

Is db2 a mainframe?

0 Answers  

What is pagespace?

1 Answers  

What is the use of db2?

0 Answers  

Can we delete records from view?

0 Answers  

Do we need cursor for Count(*)?

4 Answers   iGate,

what is the Foreign key? explain?

2 Answers  

Q1. How will you use two different DB2 qualifiers in a single COBOL program? Suppose we have 2 tables EMP1 and EMP2 with same structure defined in two different DB2 qualifiers QUAL1.EMP1 and QUAL2.EMP2 now during first 15 days we want to use QUAL1.EMP1 and rest of the days QUAL2.EMP2  how will we do this.  We can create a single program and a single load for this program. 

2 Answers   RBS,

explain about index with examples

2 Answers   Syntel,

Define data page.

0 Answers  

If I have a view which is a join of two or more tables, can this view be updatable?

3 Answers  

What is reorg and runstats in db2?

0 Answers  

For more DB2 Interview Questions Click Here
Categories