Can you please let me know the function of FILL= (X'FF')
JOIN UNPAIRED allows you to create a file with matched and unmatched records. When you code a REFORMAT statement which includes fields from both input files, the FILL parameter allows you to define a fill byte to be used for any missing p,l fields.
pls explain how the below Outfil arrived at the solution ?
The OUTFIL statement says that when the FILL character is present in the first byte of the REFORMATed record (meaning no match in File 1), BUILD the record from position 118 for the length of 117, which is the data record from File 2.
When the first criteria is not met, then BUILD=(1,117), which is the data record from File 1.
Hope this helps. Let me know if you require any further clarification.
I didn't want to post another question on the a somewhat similar subject. So, I tried to pick up the solution given here. But, obviously my requirment is a little different and I am unable tweak the given-solution to match my requiremnt. So, I need help from some one in this regard.
SYNCSORT is being used in our shop.
Input1: FB - 98
A1B2C3D4E5F6G7H8I9..... (Not all the remaining data is CHAR)
Input2: FB - 108
2009-06-26AAAABBBBCCCCDDDD... (Not all data is CHAR)
2009-06-289I8H7G6F5E4D3C2B1A... ==> dup rec - shud be skipped
If I have enough time to write code, I wouldn't be here looking for 'quick' help.
All - I fail to find any SYNCSORT documentation in this forum (or even online???) where as I could, for other tools. Perhaps, I am missing somthing obvious - please post some links for necessary documentation as I will try to look for 'workaround' solution for the stated problem.
All - I fail to find any SYNCSORT documentation in this forum
You have little chances of finding documentation for syncsort here.
different companies have different policies as far as manuals and docs are concerned.
SYNCSORT makes the docs available only to licensed customers.
ask Your support and/or have somebody get in touch with the SYNCSORT people
so that they can provide them to Your organization
I understood and accepted what Alissa had to say, and if you read all my posts - I never
tried to make my version of SYNCSORT do what it's not supposed to do. Not sure where
you got this impression from.
All I am trying to do is look for a workaround solution, if at all there is one.
I didn't know that providing links/documentation is 'doing the work'.
I also realize what you and others had to say about the copyrights issue, and
as a result started talking to support people at my work.