IBM Mainframe Forum Index
 
Log In
 
IBM Mainframe Forum Index Mainframe: Search IBM Mainframe Forum: FAQ Register
 

INCLUDE/OMIT Beyond Record


IBM Mainframe Forums -> JCL & VSAM
Post new topic   Reply to topic
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
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
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

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

New User


Joined: 02 Sep 2005
Posts: 39

PostPosted: Tue Apr 03, 2007 4:29 pm
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: 8796
Location: Welsh Wales

PostPosted: Tue Apr 03, 2007 4:39 pm
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
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: 8796
Location: Welsh Wales

PostPosted: Tue Apr 03, 2007 4:49 pm
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
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: 1208
Location: Bangalore,India

PostPosted: Tue Apr 03, 2007 5:59 pm
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
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: 1208
Location: Bangalore,India

PostPosted: Tue Apr 03, 2007 6:25 pm
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
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
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
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: 3156
Location: Tucson AZ

PostPosted: Tue Apr 03, 2007 7:46 pm
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 View Bookmarks
All times are GMT + 6 Hours
Forum Index -> JCL & VSAM

 


Similar Topics
Topic Forum Replies
No new posts ISRDSLST(3.4) Do not include addition... TSO/ISPF 0
No new posts Copy only TEXT or String from a record SYNCSORT 4
No new posts combine multiple unique records into ... DFSORT/ICETOOL 2
No new posts SORT on detail record, then repeat he... DFSORT/ICETOOL 3
No new posts how to complete the end of a record w... DFSORT/ICETOOL 2
Search our Forums:

Back to Top