SORT for sorting numeric values



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

SORT for sorting numeric values

Postby sange-sherin » Tue Dec 17, 2013 11:50 am

Hi,

I want to sort numeric fields (cols 94 to 105). So i gave sort card as

 //SYSIN    DD *             
     SORT FIELDS=(94,9,CH,A)
 /*                         
 ****************************


but i am not getting sorted output...
output:
 Command ===>                                                  Scroll ===
----+----9----+----0----+----1----+----2----+----3----+----4----+----5---
********************************* Top of Data ***************************
  -          000000005       -          ABLE STIK PRODUCTS               
  C          000000002       -          ABLE STIK PRODUCTS               
  -          000000046       00001      HAUSSER SCIENTIFIC               
  -          000000003       -          ABLE STIK PRODUCTS               
  -          000005404       -          EAST POINT PROPERTIES           


can anyone help me to find the problem?
sange-sherin
 
Posts: 25
Joined: Thu Nov 21, 2013 6:56 pm
Has thanked: 0 time
Been thanked: 0 time

Re: SORT for sorting numeric values

 

Re: SORT for sorting numeric values

Postby BillyBoyo » Tue Dec 17, 2013 1:05 pm

Is your SORTIN dataset VB? If so, you'll need to add 4 to the start position of anything, to allow for the RDW, the four bytes at the start of each V record which include information about how long an individual record is.

If your records are not variable, please post the full sysout from the step.
BillyBoyo
Global moderator
 
Posts: 3804
Joined: Tue Jan 25, 2011 12:02 am
Has thanked: 22 times
Been thanked: 264 times

Re: SORT for sorting numeric values

Postby sange-sherin » Tue Dec 17, 2013 1:32 pm

Hi Billy Boyo,

Ya, It is VB.

How to add 4 to the start position?

Can you help me to write sort card?
sange-sherin
 
Posts: 25
Joined: Thu Nov 21, 2013 6:56 pm
Has thanked: 0 time
Been thanked: 0 time

Re: SORT for sorting numeric values

Postby enrico-sorichetti » Tue Dec 17, 2013 1:58 pm

How to add 4 to the start position?
:shock: :shock: :shock:

just follow verbatim the suggestion

if the starting position for a FB record is 94
what do You get by adding 4 to it ?
cheers
enrico
When I tell somebody to RTFM or STFW I usually have the page open in another tab/window of my browser,
so that I am sure that the information requested can be reached with a very small effort
enrico-sorichetti
Global moderator
 
Posts: 2644
Joined: Fri Apr 18, 2008 11:25 pm
Has thanked: 0 time
Been thanked: 130 times

Re: SORT for sorting numeric values

Postby NicC » Tue Dec 17, 2013 3:01 pm

Why, if your field is from 94 to 105, why are you sorting only on 94 to 102?
The problem I have is that people can explain things quickly but I can only comprehend slowly.
Regards
Nic
NicC
Global moderator
 
Posts: 2692
Joined: Sun Jul 04, 2010 12:13 am
Location: Pushing up the daisys (almost)
Has thanked: 4 times
Been thanked: 105 times

Re: SORT for sorting numeric values

Postby Terry Heinze » Tue Dec 17, 2013 8:59 pm

I suspect a typo. Probably meant to say "94 through 102".
.... Terry
Terry Heinze
 
Posts: 193
Joined: Wed Dec 04, 2013 11:08 pm
Location: Richfield, MN, USA
Has thanked: 10 times
Been thanked: 11 times


Return to Syncsort/Synctool

 


  • Related topics
    Replies
    Views
    Last post