where can we use index and subscript ? with example ?
Answer Posted / 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 |
Post New Answer View All Answers
What is the difference between oracle and db2?
What is db2 connect?
can all users have the privilage to use the sql statement select * (dml)?
SQLCODE = -199, ERROR: ILLEGAL USE OF KEYWORD CHAR, TOKEN KEY was expected
Why select is not preferred in embedded sql programs?
What is the result of open cursor statement?
I HAVE 500 ROW TO UPDATE I WOULD LIKE TO USE ROLLBACK ALONG WITH COMMIT.WHAT IS THE SYNTAX TO CODE COMMIT AND ROLLBACK FOR EVERY 100 ROWS.AND HOW THE CURSOR ROLLBACK TO THE LAST COMMITTING POINT.
Explain various types of locks in db2?
Highlight all the advantages that are attached to a package.
How to execute stored procedures?
What is nvl in db2?
If the cursor is kept open followed the issuing of commit, what is the procedure to leave the cursor that way?
What is the physical storage length of time data type?
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?
What is a trigger in the db2 database?