TTTT159FILEDST20060925\XYZCMOA\
TTTT159FILEDST20060925\ZYXCMOA\
TTTT159FILEDST20060925\YZXCMOA\
<lots of other details between these records>
20060925.XYZCMOA.CD1
20060925.ZYXCMOA.CD1
20060925.YZXCMOA.CD1
Will the following include condition work for the above VB input file?
Code:
OPTION COPY
INCLUDE COND=(((28,3,CH,EQ,C'XYZ'),AND,(32,2,CH,EQ'MO')),OR,
((14,3,CH,EQ,C'XYZ'),AND,(18,2,CH,EQ'MO')))
This is wat i got from SSO after running the SORT step
Code:
WER251A INCLUDE/OMIT INVALID COND
WER211B SYNCSMF CALLED BY SYNCSORT; RC=0000
WER449I SYNCSORT GLOBAL DSM SUBSYSTEM ACTIVE
Are u using Syncsort for this ? Anyways , i just tried ur cond but there is a small error in the condition
INCLUDE COND=(((28,3,CH,EQ,C'XYZ'),AND,(32,2,CH,EQ'MO')),OR,
((14,3,CH,EQ,C'XYZ'),AND,(18,2,CH,EQ'MO')))
u have not declared the 2nd criteria within each condition as a character
try this
INCLUDE COND=(((28,3,CH,EQ,C'XYZ'),AND,(32,2,CH,EQ,C'MO')),OR,
((14,3,CH,EQ,C'XYZ'),AND,(18,2,CH,EQ,C'MO')))
And also i just used the input that u have posted and have got a zero-length data.
Joined: 14 Oct 2005 Posts: 1208 Location: Bangalore,India
Hi there,
Code:
INCLUDE COND=(((28,3,CH,EQ,C'XYZ'),AND,(32,2,CH,EQ'MO')),OR,
((14,3,CH,EQ,C'XYZ'),AND,(18,2,CH,EQ'MO')))
Since ur input file is Variable length file so it might the case that some of the record is two short to check the matching condition. I think it is used
to avoid that
One quick doubt. When i add a file header to my layout
Code:
TTTT159FILEHDR
TTTT159FILEDST20060925\XYZCMOA\
TTTT159FILEDST20060925\ZYXCMOA\
TTTT159FILEDST20060925\YZXCMOA\
<lots of other details between these records>
20060925.XYZCMOA.CD1
20060925.ZYXCMOA.CD1
20060925.YZXCMOA.CD1
TTTT159FILETRL
and modify my INCLUDE COND to include both file header and trailer[the first and last record], i'm not getting them in to output file!!!
My INCLUDE statement looks like:
INCLUDE COND=(5,14,CH,EQ,C'TTTT159FILEHDR',OR,
5,14,CH,EQ,C'TTTT159FILETRL',OR,
((28,3,CH,EQ,C'XYZ'),AND,(32,2,CH,EQ'MO')),OR,
((14,3,CH,EQ,C'XYZ'),AND,(18,2,CH,EQ'MO')))
Now the problem all records but FILEHDR and FILETRL records are getting selected?? Could you help on this?
Joined: 18 Nov 2006 Posts: 3156 Location: Tucson AZ
It's in the manual......
The delivered default of 0 instructs SyncSort to terminate if a record does not completely contain all INCLUDE or OMIT fields. A WER250A critical error message is generated to indicate this condition.
When VLTESTI=1 is specified, a record that does not completely contain all INCLUDE/OMIT fields is treated as having failed the comparison. SyncSort will omit the record if INCLUDE is being used or include the record if OMIT has been specified.
When VLTESTI=2 is specified, SyncSort will treat comparisons to fields not completely contained within the record as false and decide a record?s status for inclusion or omission from fields that are available. If all fields are not present, the record will be processed as having failed the comparison. SyncSort will omit the record if INCLUDE is being used or include the record if OMIT has been specified.
