VMS SORT Specification Sort Sequence

[Robert Atkinson]

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.

[Robert Atkinson]

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!!

[Volker Halle]

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.

[Ian McKerracher_1 · Accepted solution]

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

[Hein van den Heuvel]

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

Hein.

[Robert Atkinson]

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.