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...


where can we use index and subscript ? with example ?

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 db2 400?

0 Answers  


Why PS file called Physical seqential file?How to sore data in sequential file and ESDS file? What is the use of DBRM,PLAN,package and Collection.

1 Answers  


what are the SQL codes u freequently got?

2 Answers   Logica CMG,


how do we solve soc 7 and soc4 ?

3 Answers   Tech Mahindra,


What is a thread?

3 Answers  


What is the max length of sqlca?

0 Answers  


What is difference between isnull and coalesce?

0 Answers  


what is a plan and how do you refer the plan in the program?

2 Answers   Xansa,


how to fetch multiple records without using cursor

14 Answers   HCL,


While creating a table, by mistake you have given size of one field as 10. But as per requirement size should be 8. What is your next step?

4 Answers   CTS, IBM,


Discuss about db2 bind?

0 Answers  


How to rename a table in DB2 ?

0 Answers   MCN Solutions,


Categories