Page 2 of 2

Re: SYNSORT_PLEASE ASSIST

PostPosted: Fri Nov 04, 2011 9:11 pm
by dick scherrer
Hello,

I tried using IF=THEN but the IF=THEN construct itself not working for my SYNSORT. (Please refer my top most post)
IFTHEN is supported in Syncsort 1.3. If it is not working for you, you have done something wrong. What do you mean by "not working" - which is completely worthless to post. You have to post what you tried and what happened.

For someone here to help, you need to post all of the informational/diagnostic output generated by the run (including the message ids).

Re: SYNSORT_PLEASE ASSIST

PostPosted: Fri Nov 04, 2011 10:15 pm
by enrico-sorichetti
why not meditate a bit on what You are doing...
using a join unpaired and then selecting only the records where (1,5,CH,EQ,81,5,CH).
will nullify the unpaired option, forcing a useless join of something that will never be selected

since no record in file 2 contains the 14020 and the 14021 keys these record from file 1 will never come out

since You do not have the slightest idea on the HOW just limit Yourself to the WHAT...
restart from the beginning and without making stupid suggestions on how to do it
describe the input files and the expected output telling in plain words the logic ( why a record is included )
and forget about the IF/THE/ELSE bullshit :evil:

a good approach in understanding what is going on would be to look at the output files step by step
for example browse the joined file ( LRECL 160 ) to see how it looks like !

and keep building on Your logic from there