Join this group to access featured content and participate in discussions related to our sort products for Linux and open systems.

26 Members
Join Us!

 

hi
I need to add a sequence number to every duplicate records.
like describe in :

http://ibmmainframes.com/about48247.html


in the following page there is a description of how to do it in mainframe
can one sgest a way to do it using syncsort shell for unix ? 

Thanks

ab

You need to be a member of Syncsort Community to add comments!

Join Syncsort Community

Email me when people reply –

Replies

  • Hi Ab, 

    Can you provide some sample input and sample output? Are you looking to do some XSUM like processing? It was not very clear form the link above what the person was asking, and more importantly what his end solution was. 

    Thanks!

    Chris

    • Hi Chris
      I added an explanation to my question
      hope  i am clear now .

      am I ?

       

      Ab

    • Ab, 

      I would suggest contacting Syncsort technical support to get an answer for this issue. Please email them at techsupport@syncsort.com. 

      Thanks!

    • hi

      attached  sample, with part of my syncsort script
      I have to keep the original record with all details. yet I need to get my out file sorted and numbered with two sets of sequence, first ( in my out file sample position 1 to 3 ) would be line number, second ( in my out file sample position 4 to 6 ) would be the key number.

      Sample for in file:

       

      001abc01z000000000000000360

      002abd01z000000000082540500

      002abd01z000000000000000987

      002abe01z000000000009873600

      001abc01z000000000000001000

      003abc01z000000000005020400

      001abc03z000000000000003604

      001abc02z000000000000025800

      001abc02z000000000000000000

      001abc02z000000000008845900

      003abc01z000000000009743920

      002abe01z000000000072409700

       

      <Syncsort Script is proprietary, so not listed here>  

       

      Expected out file:

       

      001001001abc01z000000000000000360

      002001001abc01z000000000000001000

      003002001abc02z000000000008845900

      004002001abc02z000000000000025800

      005002001abc02z000000000000000000

      006003001abc03z000000000000003604

      007004002abd01z000000000082540500

      008004002abd01z000000000000000987

      009005002abe01z000000000072409700

      010005002abe01z000000000009873600

      011006003abc01z000000000005020400

      012006003abc01z000000000009743920

       

       

This reply was deleted.

To access Syncsort Knowledge Base, visit:

My Support