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 is the use of value function?

0 Answers  


What is coalesce in db2?

0 Answers  


How do you select a row using indexes in db2?

0 Answers  


What is deadlock?

2 Answers  


What is SPUFI?

4 Answers  






How to get the ddl of a table in db2?

0 Answers  


What is access path in db2?

0 Answers  


Why might full image copies be faster to implement than an incremental image copy?

4 Answers  


What are some characteristics of columns that benefit from indexes?

1 Answers  


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

3 Answers  


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

4 Answers  


Is schema the same as database?

0 Answers  


Categories