Ascending is the default, you can specify Descending after each field as shown in Raymonds example:
FOR RFILE IN MPEXFILESET
SORT (SECTORS:'DESC',(TODAY-ACCDATE):'DESC',INTCODE,RHT(FILE,2):2)
It is also in the manual that Paul posted yesterday on page 201.
Neil
From: HP-3000 Systems Discussion <[log in to unmask]> on behalf of "Johnson, Tracy" <[log in to unmask]>
Reply-To: "Johnson, Tracy" <[log in to unmask]>
Date: Tuesday, September 12, 2017 at 13:38
To: <[log in to unmask]>
Subject: Re: [HP3000-L] MPEX LISTF Sorting
Now all it needs is an Ascending vs. Descending sort option.
Tracy Johnson
+00 1 757 766-4318 tel
+00 1 757 755-6470 mobile
Hampton, Virginia, U.S.
[log in to unmask]
-----Original Message-----
From: HP-3000 Systems Discussion [mailto:[log in to unmask]] On Behalf
Of Legault, Raymond D
Sent: Tuesday, September 12, 2017 8:25 AM
To: [log in to unmask]
Subject: Re: [HP3000-L] MPEX LISTF Sorting
________________________________
Here is one from my system.
FILE PIGLF.LISTF.VESOFT
FOR RFILE IN MPEXFILESET
SORT (SECTORS:'DESC',(TODAY-ACCDATE):'DESC',INTCODE,RHT(FILE,2):2)
FIRST
BEGIN
WRITELN (" FILE GROUP ACCOUNT CNT",
" FCODE LAST ACCESS DAYS ");
WRITELN ("=====================================",
"======================================");
WRITELN (" ");
END
DO
WRITELN (TAB(2), FILE,
TAB(14),GROUP,
TAB(26),SECTORS:8,
TAB(40),TOTAL(1,1),
TAB(50),CODE,
TAB(60),ACCDATE,
TAB(73),(TODAY-ACCDATE)
);
Ray
-----Original Message-----
From: John Sommer [mailto:[log in to unmask]]
Sent: Monday, September 11, 2017 11:46 AM
Subject: MPEX LISTF Sorting
All,
Does anyone know how to get VESoft's MPEX LISTF command to sort the file
output?
In this case, I just simply want it to sort the files by their creation
date.
Thanks for any information,
John
* To join/leave the list, search archives, change list settings, *
* etc., please visit http://raven.utc.edu/archives/hp3000-l.html *
* To join/leave the list, search archives, change list settings, *
* etc., please visit http://raven.utc.edu/archives/hp3000-l.html *
|