Interested to Buy Any Domain ? << Click Here >> for more details...
where can we use index and subscript ? with example ?
- 3 Answers
- 11187 Views
- CTS, I also Faced
- E-Mail Answers
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 |
How to fetch the uncommited data from table ?
What is the clustering index in the db2 database?
What will the FREE command do to a plan?
What do the initials DDL and DML stand for and what is their meaning?
If I have a view which is a join of two or more tables, can this view be updateable?
What are the uses of db2 optimizer?
Why do chiropractors use drop table?
Which transaction use a command thread ?
OUTER JOINS USED TO GET MATCHING AND NONMATCHING ROWS FORM 2 OR MORE TABLES BASED ON COLUMNS. SIMPLE JOINS ALSO DO THE SAME THEN WHAT IS THE USE OF OUTER JOINS.
What is clone table?
I am getting a error multiple row fetched while executing a Cobol-DB2 program.How can I solve it without using a cursor.
pls tell me abt the normalization five types....
COBOL 
