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

where can we use index and subscript ? with example ?

Question Posted / visu.kanchamreddy

Answers were Sorted based on User's Feedback



where can we use index and subscript ? with example ?..

Answer / tej

In addition to the above,
subscript is like a working storage variable
abc pic 999.
Using index the search for the data is faster since it gives
the object location(displacement) directly.
Subscript can be modified by ADD,SUBTRACT etc
Index modification is UP BY,DOWN BY

and yeah this q should have been in cobol section ;)

Is This Answer Correct ?    4 Yes 1 No

where can we use index and subscript ? with example ?..

Answer / lu

Subscript refers to the array occurrence while index is the
displacement (in no of
bytes) from the beginning of the array. An index can only
be modified using PERFORM, SEARCH & SET.
Need to have index for a table in order to use SEARCH,
SEARCH ALL.
This is cobol, not DB2....

Is This Answer Correct ?    4 Yes 2 No

where can we use index and subscript ? with example ?..

Answer / shivankoo

The question is where(in which scenario) we use subscript
and where we use index and not what is index and subscript.

Is This Answer Correct ?    0 Yes 1 No

Post New Answer

More DB2 Interview Questions

What is a DB2 catalog?

2 Answers  

What is the significance of DB2 free space and what parameters control it?

1 Answers  

what is + sign and -ve sign for sql code ?

1 Answers   TCS,

In db2, how do you insert multiple rows in 1 query using a.) Cursors, b.) Normal query?? Give syntax for both.

5 Answers   CTS,

I have a subprogram B calling from mainprogram A.I have opened a cursor in A ,Can i fetch the same cursor in subprogram B , If yes , Please explain the reason?

1 Answers   HeadStrong,

When do you specify the isolation level? How?

1 Answers  

How is a typical db2 batch pgm executed?

0 Answers  

What is referential integrity?

5 Answers  

How can i install db2 9.x on AIX based system..? plz reply the detailed steps involved....?

0 Answers   IBM, TCS,

What is meant by explain?

0 Answers  

What does runstats do in db2?

0 Answers  

What parameters are used to control the free space in DB2?

0 Answers  

For more DB2 Interview Questions Click Here
Categories