need help in synsort

raj12vel · Posted: Fri May 08, 2009 10:58 pm

Hi All,

I have one input file length of 80 bytes.

There is one field at position 71 (lenth of 7 bytes). Lets say user-id.

I need to fetch only user-id from that file and also that field needs to be sorted on ascending order and duplicates needs to be removed.

So the output file should contain only user-id field which is sorted with no-dups.

Can any one help me on this???

thanks in advance.

cpuhawg · Posted: Fri May 08, 2009 11:46 pm

You need a card to sort:

Succor · Posted: Fri May 08, 2009 11:50 pm

Raj12vel,You can try this ,altering the data type if required.

Arun Raj · Posted: Fri May 08, 2009 11:58 pm

It might be more efficient to select ONLY the required field BEFORE sorting using INREC rather than removing the unwanted fields after sorting using an OUTREC. Just a thought.

raj12vel · Posted: Sat May 09, 2009 12:29 am

Hi all,

Thanks for all your response!!!

the below statement meets my last requirement.

OUTREC FIELDS=(1:71,7,8:73C' ')

but getting an error

INREC RECORD LENGTH = 7
OUTREC FIELD OUTSIDE RANGE

please help me on this.

All other code works fine but getting buffer values at the remaining position of the output file. thats why going for this command to make the remaining field as spaces.

CICS Guy · Posted: Sat May 09, 2009 12:32 am

raj12vel · Posted: Sat May 09, 2009 12:36 am

Hi All,

I tried with these cards,

cpuhawg · Posted: Sat May 09, 2009 12:40 am

There needs to be a space between SUM and FIELDS=NONE

raj12vel · Posted: Sat May 09, 2009 12:44 am

Great!!!

Thanks alot your timed help!!!

raj12vel · Posted: Sat May 09, 2009 12:45 am

Thank you all!!!

All the cards work fine now...

dick scherrer · Posted: Sat May 09, 2009 1:06 am

Hello,

Is there some reason you chose to sort all of the data instead of only the 7 bytes you wanted as output?

If you have 50 records it will not matter, if you have 50 millon records, it will. . .

raj12vel · Posted: Sat May 09, 2009 1:27 am

Need to have it. Thats why. Any ways thanks alot.

Got another situation here.

I have two input files.

1. Length of 80 bytes (user-id at position 71, length of 7 bytes)

2. length of 80 bytes (user-id at position 01,length of 7 bytes)

requirement:-

1. User id needs to be matched with both files,

2. if matches, then all the records from 1st file (80 bytes) and the field from position 09 to 10 (i.e 2 bytes) will be written into the output.

can any one help me on this?

raj12vel · Posted: Sat May 09, 2009 1:36 am

Input:-

I have two input files.

1. Length of 80 bytes (user-id at position 71, length of 7 bytes)

2. length of 80 bytes (user-id at position 01,length of 7 bytes)

requirement:-

1. User id needs to be matched with both files,

2. if matches, then all the records from 1st file (80 bytes) and the field from position 09 to 10 (i.e 2 bytes) will be written into the output.

can any one help me on this?
_________________

dick scherrer · Posted: Sat May 09, 2009 1:55 am

Hello,

Suggest you look at join/joinkeys in the Syncsort manual.

There are also multiple examples in the forum (SEARCH link is above).

If you find something that is not clear, p[ost what you found and someone will be able to clarify.

raj12vel · Posted: Sat May 09, 2009 2:35 am

Hi,

Got the code for the above question..

Thanks alot.

But if there is no match between the user-id's then need to populate
the value as "???" in the output file?

here what condition we have to include...

here is the code i have used now:-

//SYSIN DD *
JOINKEYS FILE=F1,FIELDS=(71,07,A)
JOINKEYS FILE=F2,FIELDS=(01,07,A)
REFORMAT FIELDS=(F1:1,80,F2:9,2)
SORT FIELDS=(71,7,CH,A)
OUTREC FIELDS=(1,80,81,02,83:8C' ')
/*

please help me on this...

CICS Guy · Posted: Sat May 09, 2009 5:16 am

Have you looked at the idea of mulitpule OUTRECs pointing to the same output?

Arun Raj · Posted: Sat May 09, 2009 9:47 am

raj12vel · Posted: Mon May 11, 2009 11:17 pm

1. Input File1

Arun Raj · Posted: Fri May 15, 2009 10:44 am

raj12vel,

Your field positions in the sample data(key at pos-50) does n't seem to match with what you've used in your sort cards(pos-71). The below JOIN UNPAIRED application should work for you. You can modify the field positions as in your actual file.