Portal | IBM Manuals | Downloads | Products | Refer | Info | Programs | JCLs | Forum Rules*| Site Map | Mainframe CD 
IBMMAINFRAMES.com - IBM Mainframe Support Forums Index
 
Register
 
IBMMAINFRAMES.com - IBM Mainframe Support Forums Index FAQ Search Memberlist Usergroups Profile Log in to check your private messages Log in
 
SYNCSORT OMIT condition execution error
Goto page Previous  1, 2
 
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> JCL
Author Message
arcvns

Senior Member


Joined: 17 Oct 2006
Posts: 802
Location: Chennai, India

PostPosted: Mon Sep 15, 2008 2:14 pm    Post subject:
Reply with quote

Anuj,

Just thought of sharing some info. I tried executing exactly the same jcl and input records as yours, but failed with RC=16 showing the below error.
Code:
WER250A  INCLUDE/OMIT FIELD BEYOND RECORD

and the same job went thru fine with RC=0 giving when I modified the card as
Code:
//SYSIN    DD *                 
  OPTION COPY,VLSHRT             
  INCLUDE COND=(29,01,CH,EQ,C'A')

VLSHRT specifies that records that are too short to contain all of the INCLUDE compare fields are not to be included in the output data set.
Though VLSHRT is a DFSORT option it works with Syncsort as well.

Alternatively, you can specify the VLTESTI parameter in SYNCSORT to handle short records in INCLUDE/OMIT as below.
Code:
//STEP01   EXEC PGM=SORT,PARM='VLTESTI=1'


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.

Thanks,
Arun
Back to top
View user's profile Send private message
References
Display posts from previous:   
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> JCL All times are GMT + 6 HoursGoto page Previous  1, 2
Page 2 of 2