I have tried the query of READ a file by ASCENDING and DESCENDING order.
For ex: File CLASS-NAME contains the columns as shown with NAME being a descriptor,
Roll No. Name
READ CLASS-NAME BY NAME = ‘CCC’ ASCENDING returns:
READ CLASS-NAME BY NAME = ‘CCC’ DESCENDING returns
- What is the performance implication of having a DESCENDING parameter for a read? Does it make any difference at all?
- Can ADABAS return the result set of a query in DESCENDING order?