How to perfrom sort on the below condition ?



Support for NetApp SyncSort for z/OS, Visual SyncSort, SYNCINIT, SYNCLIST and SYNCTOOL

How to perfrom sort on the below condition ?

Postby Dharma1995 » Tue Jan 23, 2018 1:25 pm

i am having the below record,

input :

1111 000020.50
1111 000340.50
1111 000100.50
2222 080000.40
3333 000040.40
4444 000100.50
3333 000100.50
2222 000100.50

sort cards :

//SYSIN DD *
OPTION ZDPRINT
SORT FIELDS=(1,4,ZD)
SUM FIELDS=(6,9,ZD)
/*

required output :

1111 000461.50
2222 080100.90
3333 000140.90
4444 000100.50

i am getting Soc7 error , how should i define the format of the decimal digits
Dharma1995
 
Posts: 1
Joined: Tue Jan 23, 2018 1:18 pm
Has thanked: 0 time
Been thanked: 0 time

Re: How to perfrom sort on the below condition ?

Postby Robert Sample » Tue Jan 23, 2018 7:46 pm

Decimal points are not numeric. Try the UFF format.
Robert Sample
Global moderator
 
Posts: 3720
Joined: Sat Dec 19, 2009 8:32 pm
Location: Dubuque, Iowa, USA
Has thanked: 1 time
Been thanked: 279 times


Return to Syncsort/Synctool

 


  • Related topics
    Replies
    Views
    Last post