SYNCSORT Help

chatterjesis · New User Joined: 31 Aug 2008 Posts: 31 Location: hyderabad

I have 2 PS files.
And I need to create 3rd file with entries which are present in file 1 but not in file 2, using syncsort.

File 1 structure is as below,

chatterjesis · New User Joined: 31 Aug 2008 Posts: 31 Location: hyderabad

The structure got distorted in the above post

FIXED

Column 1 starts at position 1 and column 2 starts are position 16 for both F1 and F2.

I am really sorry for the formatting error.

rmaruri · New User Joined: 29 Jun 2005 Posts: 13 Location: USA

Use SORT JOIN.

Here is the sample. Change it as per the requirement.

JOINKEYS FILES=F1,FIELDS=(1,6,A)
JOINKEYS FILES=F2,FIELDS=(1,6,A)
JOIN UNPAIRED F1,ONLY
REFORMAT FIELDS=(F1:1,6)
SORT FIELDS=COPY

chatterjesis · New User Joined: 31 Aug 2008 Posts: 31 Location: hyderabad

I was using the same code as suggested but this one gives, along with ABC 6767

5678
9233
3333

comes in the output, but i need only the below entry
ABCD 6767

Bill Woodger · Posted: Mon Jun 06, 2011 5:59 pm

I suppose if you don't want the blank keys at all, just OMIT them.

If the blank keys are supposed to inherit the key value of the previous non-blank key, then you'll need to do a bit of tinkering.

chatterjesis · New User Joined: 31 Aug 2008 Posts: 31 Location: hyderabad

Thanks Bill for the reply...
Yes, you got it correct, the blank fields should retain the previous non blank values. Is there any looping facility? or something to keep it stored?

Thanks in advance.

Bill Woodger · Posted: Tue Jun 07, 2011 12:10 am

I don't think there is any "looping" available. I think you can define groups of records such that they can be processed with the key from the first record in the group.

I'd look at the manual Table of Contents and Index. Search this forum. Search the internet. Hope that someone with more specific knowledge than I have picks this up again :-)

Unfortunately, SYNCSORT manuals are not generally available unless you are entitled to one, which I'm not.

sqlcode1 · Active Member Joined: 08 Apr 2010 Posts: 577 Location: USA

chatterjesis,

Tried on DFSort but should work on Syncsort. AFAIK, Syncsort doesn't allow "subtasking".
Also,why do you need output with 80 bytes? If you are just selecting unmatched records from file1, shouldn't your output be 32 bytes only?

chatterjesis · New User Joined: 31 Aug 2008 Posts: 31 Location: hyderabad

Thanks a lot!
This one worked like wonder!

prasanth_thavva · New User Joined: 28 Jul 2005 Posts: 86 Location: Chennai

Even we can use OMIT COND to eliminate the records which has spaces in first 4 bytes and then in the next step we can use join keys to un matched records from file A i think achieve the results

sqlcode1 · Active Member Joined: 08 Apr 2010 Posts: 577 Location: USA

Prasanth

prasanth_thavva · New User Joined: 28 Jul 2005 Posts: 86 Location: Chennai

Sql'

Thanks, but actually i would like to figure out what exactly below card does when it executes

OUTREC IFTHEN=(WHEN=GROUP,BEGIN=(1,4,CH,GT,C' '),PUSH=(1:1,4))

I have got it like if the first 4 bytes are spaces push, but exactly what push command does ? can you explain me

whether it will write this in temporary area if it a has spaces in first 4 bytes

dick scherrer · Posted: Sat Jun 18, 2011 11:08 pm

Hello,