where can we use index and subscript ? with example ?
Answers were Sorted based on User's Feedback
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 |
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 |
What if , we failed to mentioed null indicator in sql select query , that may retrieve null value ?
can any one give the list of some important sql abend codes which r frequently asked in interviews?
What's the maximum number of volumes that can be added to a STOGROUP?
Why might full image copies be faster to implement than an incremental image copy?
What is performance tuning db2?
What is the specific need of Plan and..where are the tables in DB2 are physically saved
In cobol+DB2program if the code of cobol program has changed than i have to do precompilation once again?
What is image copy?
When DB2 connection fails, will online program work or give errors.
How to create a table using embedded sql?
What is database reorganization?
What db2 400?