Portal | Manuals | References | Downloads | Info | Programs | JCLs | Mainframe wiki | Quick Ref
IBM Mainframe Computers Forums Index
 
Register
 
IBM Mainframe Computers Forums Index Mainframe: Search IBM Mainframe Forum: FAQ Memberlist Profile Log in to check your private messages Log in
 
Syncsort Error: INCLUDE/OMIT INVALID COND

 
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> JCL & VSAM
View previous topic :: :: View next topic  
Author Message
itzphaniz

New User


Joined: 02 Sep 2005
Posts: 39

PostPosted: Tue Apr 03, 2007 3:25 pm    Post subject: Syncsort Error: INCLUDE/OMIT INVALID COND
Reply with quote

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
View user's profile Send private message

umavivekanand

New User


Joined: 26 Apr 2006
Posts: 5
Location: Banglore

PostPosted: Tue Apr 03, 2007 4:08 pm    Post subject:
Reply with quote

Hi itzphaniz

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.

Let me know if this answers ur qry..
Back to top
View user's profile Send private message
itzphaniz

New User


Joined: 02 Sep 2005
Posts: 39

PostPosted: Tue Apr 03, 2007 4:29 pm    Post subject:
Reply with quote

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
View user's profile Send private message
expat

Global Moderator


Joined: 14 Mar 2007
Posts: 8619
Location: Back in jolly old England

PostPosted: Tue Apr 03, 2007 4:39 pm    Post subject:
Reply with quote

What does it say about the WER250A message in the manual ?
Back to top
View user's profile Send private message
itzphaniz

New User


Joined: 02 Sep 2005
Posts: 39

PostPosted: Tue Apr 03, 2007 4:48 pm    Post subject:
Reply with quote

INCLUDE/OMIT FIELD BEYOND RECORD is wat i got from SSO.
Back to top
View user's profile Send private message
expat

Global Moderator


Joined: 14 Mar 2007
Posts: 8619
Location: Back in jolly old England

PostPosted: Tue Apr 03, 2007 4:49 pm    Post subject:
Reply with quote

Does not the manual give a more detailed description of the problem than that ?
Back to top
View user's profile Send private message
itzphaniz

New User


Joined: 02 Sep 2005
Posts: 39

PostPosted: Tue Apr 03, 2007 5:22 pm    Post subject:
Reply with quote

I couldn't get any useful information from manual icon_sad.gif
Back to top
View user's profile Send private message
guptae

Moderator


Joined: 14 Oct 2005
Posts: 1187
Location: Bangalore,India

PostPosted: Tue Apr 03, 2007 5:59 pm    Post subject:
Reply with quote

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
View user's profile Send private message
itzphaniz

New User


Joined: 02 Sep 2005
Posts: 39

PostPosted: Tue Apr 03, 2007 6:19 pm    Post subject:
Reply with quote

thanks a ton! Its working.
Now here comes another question?wat does this parm field do?? icon_wink.gif
Back to top
View user's profile Send private message
guptae

Moderator


Joined: 14 Oct 2005
Posts: 1187
Location: Bangalore,India

PostPosted: Tue Apr 03, 2007 6:25 pm    Post subject:
Reply with quote

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
View user's profile Send private message
itzphaniz

New User


Joined: 02 Sep 2005
Posts: 39

PostPosted: Tue Apr 03, 2007 6:58 pm    Post subject:
Reply with quote

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
View user's profile Send private message
itzphaniz

New User


Joined: 02 Sep 2005
Posts: 39

PostPosted: Tue Apr 03, 2007 7:21 pm    Post subject:
Reply with quote

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 icon_smile.gif
Back to top
View user's profile Send private message
itzphaniz

New User


Joined: 02 Sep 2005
Posts: 39

PostPosted: Tue Apr 03, 2007 7:36 pm    Post subject:
Reply with quote

Can anyone please tell me the difference between PARM='VLTESTI=2' and PARM='VLTESTI=1'??
Back to top
View user's profile Send private message
William Thompson

Global Moderator


Joined: 18 Nov 2006
Posts: 3158
Location: Tucson AZ

PostPosted: Tue Apr 03, 2007 7:46 pm    Post subject:
Reply with quote

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
View user's profile Send private message
View previous topic :: :: View next topic  
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> JCL & VSAM All times are GMT + 6 Hours
Page 1 of 1

 

Search our Forum:

Similar Topics
Topic Author Forum Replies Posted
No new posts query to fetch record which has only ... maxsubrat DB2 12 Mon Dec 11, 2017 5:03 pm
No new posts -502 Error - Cursor already open anand jeyapaul DB2 7 Sun Oct 29, 2017 4:22 am
No new posts IEW2456E error when link-editing a C ... Senthilraj JCL & VSAM 0 Fri Oct 13, 2017 3:12 pm
No new posts FTP Skip or ignore error and process ... AJAYREDDY All Other Mainframe Topics 3 Wed Sep 27, 2017 8:12 pm
No new posts Assembler Macro Copybook converted to... Ziquilix PL/I & Assembler 4 Tue Sep 26, 2017 3:07 am

Facebook
Back to Top
 
Job Vacancies | Forum Rules | Bookmarks | Subscriptions | FAQ | Polls | Contact Us