I'm spending way too much time in SQL. I knew DESC mean descending.
It's all POV-related, isn't it.
Denys
-----Original Message-----
From: HP-3000 Systems Discussion [mailto:[log in to unmask]] On Behalf Of Neil Armstrong
Sent: Tuesday, September 12, 2017 1:52 PM
To: [log in to unmask]
Subject: Re: [HP3000-L] MPEX LISTF Sorting
Which is usually what we all saw and thought it meant in 99.9999999% of the database schemas we all have worked with. LOL.
Neil
From: HP-3000 Systems Discussion <[log in to unmask]> on behalf of John Sommer <[log in to unmask]>
Reply-To: <[log in to unmask]>
Date: Tuesday, September 12, 2017 at 14:48
To: <[log in to unmask]>
Subject: Re: [HP3000-L] MPEX LISTF Sorting
For a while, I thought it meant "DESCRIPTION".
-----Original Message-----
To: HP3000-L <[log in to unmask]>
Sent: Tue, Sep 12, 2017 1:31 pm
Subject: Re: [HP3000-L] MPEX LISTF Sorting
Now I know what ‘DESC’ stood for.
Tracy Johnson
+00 1 757 766-4318 tel
+00 1 757 755-6470 mobile
Hampton, Virginia, U.S.
[log in to unmask]
From: Neil Armstrong [mailto:[log in to unmask]]
Sent: Tuesday, September 12, 2017 2:17 PM
To: Johnson, Tracy <[log in to unmask]>; [log in to unmask]
Subject: Re: [HP3000-L] MPEX LISTF Sorting
The following message was sent from an external e-mail address. Be cautious when clicking on links, opening attachments or providing sensitive information.
________________________________
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]<mailto:[log in to unmask]>> on behalf of "Johnson, Tracy" <[log in to unmask]<mailto:[log in to unmask]>>
Reply-To: "Johnson, Tracy" <[log in to unmask]<mailto:[log in to unmask]>>
Date: Tuesday, September 12, 2017 at 13:38
To: <[log in to unmask]<mailto:[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]<mailto:[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]<mailto:[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 *
* 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 *
* To join/leave the list, search archives, change list settings, *
* etc., please visit http://raven.utc.edu/archives/hp3000-l.html *
|
