topic Re: VMS SORT Specification Sort Sequence in Operating System - OpenVMS

VMS SORT Specification Sort Sequence

Robert Atkinson — Fri, 23 Sep 2005 11:06:52 GMT

Anyone know where the ascending/descending should go in the SORT Specification??

ALPHA_ROB$$ SORT /SPECIFICATION=robsort.tmp /sequ dsk$webreports rob.tmp

ALPHA_ROB$$ typ robsort.tmp
/field=(name=report,pos=1,size=15)
/field=(name=group,pos=83,size=10)
/field=(name=record,pos=1,size=200)
/condition=(name=select_report1,
test=(group eq "WHMANAGER " ))
/include=(condition=select_report1,key=report,data=record)
ALPHA_ROB$$

Cheers, Rob.

Re: VMS SORT Specification Sort Sequence

Robert Atkinson — Fri, 23 Sep 2005 11:15:30 GMT

Tried adding '/key' to the bottom, but no joy :-

/field=(name=report,pos=1,size=15)
/field=(name=group,pos=83,size=10)
/field=(name=record,pos=1,size=200)
/condition=(name=select_report1,
test=(group eq "WHMANAGER " ))
/include=(condition=select_report1,key=report,data=record)
/key=(report,descending)

Off home to think about it for the weekend!!

Re: VMS SORT Specification Sort Sequence

Volker Halle — Fri, 23 Sep 2005 11:53:49 GMT

Robert,

there is one example (see example 1) in the manual, which talks about ascending/descending:

http://h71000.www7.hp.com/doc/731FINAL/6489/6489pro_022.html#srt_specification_file

It looks a bit complicated though...

Volker.

Re: VMS SORT Specification Sort Sequence

Ian McKerracher_1 — Fri, 23 Sep 2005 11:54:01 GMT

Hello Rob,

Try using either

/include=(condition=select_report1,key=(report,descending),data=record)

or

/include=(condition=select_report1,data=record)
/key=(report,descending)

Regards,

Ian

Re: VMS SORT Specification Sort Sequence

Hein van den Heuvel — Fri, 23 Sep 2005 12:19:45 GMT

Just put the word acsending or descending with the key spec: /key=(report,desc)

Hein.

Re: VMS SORT Specification Sort Sequence

Robert Atkinson — Mon, 26 Sep 2005 03:13:41 GMT

Cheers guys. I'd tried "key=report,descending" but didn't think to put it in parenthasis!

This line worked fine for my sort spec in the end :-

/include=(condition=select_report1,key=(report,descending),data=record)

Rob.