Sorting a FB file



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

Sorting a FB file

Postby ansh_4702 » Thu Jul 02, 2009 5:14 pm

Hello,

My i/p file is having following records:
5
98
8
27
1
when we view this doing "hex-on" it shows trailing nulls after the actual values, like this:
5
F4444444444444
50000000000000
--------------
98
FF444444444444
98000000000000
--------------
8
F4444444444444
80000000000000
--------------
27
FF444444444444
27000000000000

when I am using following sort card for this to get the correct sorted data:
//SYSIN DD *
SORT FIELDS=(1,2,CH,A)
SUM FIELDS=NONE
/*
From this I am getting o/p as,
1
27
5
8
98

Meaning it is considering the first value "1" as "10" and similarly for others. But I want this to not consider the trailing nulls (meaning consider it as "1" only). Could any one suggest anything on this sothat I could get the following output in the correct sort order that i want(the length of i/p file is 80 and same is of o/p):
1
5
8
27
98
Please help.
ansh_4702
 
Posts: 33
Joined: Thu Jan 08, 2009 2:27 pm
Has thanked: 0 time
Been thanked: 0 time

Re: Sorting a FB file

 

Re: Sorting a FB file

Postby dick scherrer » Thu Jul 02, 2009 11:11 pm

Hello,

There are no trailing nulls - an x'40' is a space. . .

In your sort statement, try UFF instead of CH.
Hope this helps,
d.sch.
User avatar
dick scherrer
Global moderator
 
Posts: 6304
Joined: Sat Jun 09, 2007 8:58 am
Has thanked: 3 times
Been thanked: 91 times

Re: Sorting a FB file

Postby ansh_4702 » Thu Jul 02, 2009 11:38 pm

Thanks so much Dick.....it worked !! I didnt knw abt this before....thanks again for your quick help on this.
ansh_4702
 
Posts: 33
Joined: Thu Jan 08, 2009 2:27 pm
Has thanked: 0 time
Been thanked: 0 time

Re: Sorting a FB file

Postby dick scherrer » Thu Jul 02, 2009 11:39 pm

You're welcome - thanks for letting us know it is working :)

d
User avatar
dick scherrer
Global moderator
 
Posts: 6304
Joined: Sat Jun 09, 2007 8:58 am
Has thanked: 3 times
Been thanked: 91 times


Return to Syncsort/Synctool

 


  • Related topics
    Replies
    Views
    Last post