|
View previous topic :: View next topic
|
| Author |
Message |
itzphaniz
New User
Joined: 02 Sep 2005
Posts: 39
|
|
|
|
| Code: |
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 |
|
|
| Back to top |
|
 |
umavivekanand
New User
Joined: 26 Apr 2006
Posts: 5
Location: Banglore
|
|
|
|
Hi itzphaniz
Are u using Syncsort for this ? Anyways , i just tried ur cond but there is a small error in the condition
| 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'))) |
u have not declared the 2nd criteria within each condition as a character
try this
| Code: |
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.
Let me know if this answers ur qry.. |
|
| Back to top |
|
|
itzphaniz
New User
Joined: 02 Sep 2005
Posts: 39
|
|
|
|
Uma-
It was a mistake from my side. I modified the include condition.
However i'm still getting the error. INCLUDE/OMIT FIELD BEYOND RECORD
| Code: |
WER250A INCLUDE/OMIT FIELD BEYOND RECORD
WER211B SYNCSMF CALLED BY SYNCSORT; RC=0000
WER449I SYNCSORT GLOBAL DSM SUBSYSTEM ACTIVE |
Yes i'm using SYNCSORT, as it obvious from the WER messages. |
|
| Back to top |
|
|
expat
Global Moderator
Joined: 14 Mar 2007
Posts: 8796
Location: Welsh Wales
|
|
|
|
| What does it say about the WER250A message in the manual ? |
|
| Back to top |
|
|
itzphaniz
New User
Joined: 02 Sep 2005
Posts: 39
|
|
|
|
| INCLUDE/OMIT FIELD BEYOND RECORD is wat i got from SSO. |
|
| Back to top |
|
|
expat
Global Moderator
Joined: 14 Mar 2007
Posts: 8796
Location: Welsh Wales
|
|
|
|
| Does not the manual give a more detailed description of the problem than that ? |
|
| Back to top |
|
|
itzphaniz
New User
Joined: 02 Sep 2005
Posts: 39
|
|
|
|
I couldn't get any useful information from manual  |
|
| Back to top |
|
|
guptae
Moderator
Joined: 14 Oct 2005
Posts: 1208
Location: Bangalore,India
|
|
|
|
Hi There,
Try by giving PARM='VLTESTI=1' as followed
| Code: |
| //STEP001 EXEC PGM=SORT,PARM='VLTESTI=1' |
Let us know the result |
|
| Back to top |
|
|
itzphaniz
New User
Joined: 02 Sep 2005
Posts: 39
|
|
|
|
thanks a ton! Its working.
Now here comes another question?wat does this parm field do??  |
|
| Back to top |
|
|
guptae
Moderator
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 |
|
| Back to top |
|
|
itzphaniz
New User
Joined: 02 Sep 2005
Posts: 39
|
|
|
|
Ekta-
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? |
|
| Back to top |
|
|
itzphaniz
New User
Joined: 02 Sep 2005
Posts: 39
|
|
|
|
Bingo,
I just modified the PARM from
| Code: |
| //STEP001 EXEC PGM=SORT,PARM='VLTESTI=1' |
to
| Code: |
| //STEP001 EXEC PGM=SORT,PARM='VLTESTI=2' |
and its working. It was a fluke though  |
|
| Back to top |
|
|
itzphaniz
New User
Joined: 02 Sep 2005
Posts: 39
|
|
|
|
| Can anyone please tell me the difference between PARM='VLTESTI=2' and PARM='VLTESTI=1'?? |
|
| Back to top |
|
|
William Thompson
Global Moderator
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. |
|
| Back to top |
|
|
|
|
|
