SYNCTOOL or SYNCSORT Join Question



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

SYNCTOOL or SYNCSORT Join Question

Postby bcdgall » Fri Jul 23, 2010 4:34 am

I was trying to use a splice to do this operation Syncsort or SyncTool code but have not had success.

I have 2 files which consist of the following
ID 5 bytes long starting position 1
Space 1 byte long
Type of Id 3 bytes long
Space 1 byte long
Id Count 5 bytes

SBA File sample
1234 SBA 00001
12578 SBA 00005
126 SBA 00003 <-- not in INV file

INV File sample
1234 INV 00001
124 INV 00006 <-- not in SBA file
12578 INV 00005

These conditions can occur
The INV file may not have a matching Id Count for the same Id in the SBA file
The SBA file may not have a matching Id Count for the same Id in the INV file

The resulting file is to be

SBAINV File sample
1234 SBA 00001 INV 00001
124 SBA 00000 INV 00006 <-- Since INV Id does not exist in SBA file create place holder with count of zero
12578 SBA 00005 INV 00005
126 SBA 00003 INV 00000 <-- Since SBA Id does not exist in INV file create place holder with count of zero

So basically if an ID exists in one file and not in the other it should also be put into the output file with a count
value of zero for its ID

thanks
Dave
bcdgall
 
Posts: 2
Joined: Fri Jul 23, 2010 4:21 am
Has thanked: 0 time
Been thanked: 0 time

Re: SYNCTOOL or SYNCSORT Join Question

 

Re: SYNCTOOL or SYNCSORT Join Question

Postby arcvns » Thu Jul 29, 2010 12:58 am

1234 SBA 00001
As per your post, ID is 5 bytes long, but the above record shows only 4 bytes!
Arun
User avatar
arcvns
 
Posts: 55
Joined: Sat Feb 28, 2009 12:36 am
Location: India
Has thanked: 0 time
Been thanked: 0 time


Return to Syncsort/Synctool

 


  • Related topics
    Replies
    Views
    Last post