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

Syncsort problem INCLUDE/OMIT INVALID COND


IBM Mainframe Forums -> JCL & VSAM
Post new topic   Reply to topic
View previous topic :: View next topic  
Author Message
pjnithin

Active User


Joined: 22 Dec 2005
Posts: 116

PostPosted: Thu Nov 15, 2007 1:15 pm
Reply with quote

I am running a sort job as given below. But I am getting the below mentioned error. The 'WHEN' verb used is not accepted, and also some other messages are given below. The input file I am using is a VB file and converting to the FB file. The sysout is given below.

SYSIN :
SORT FIELDS=(COPY),EQUALS
INCLUDE COND=((5,5,CH,EQ,C'36308'),AND,
((45,5,CH,EQ,C'OHCOG',AND,207,2,CH,EQ,C'RS'),
OR,(45,5,CH,EQ,C'OHCOG',AND,207,2,CH,EQ,C'RW'),
OR,(45,5,CH,EQ,C'OHCO1',AND,207,2,CH,EQ,C'RS'),
OR,(45,5,CH,EQ,C'OHCO1',AND,207,2,CH,EQ,C'RW'),
OR,(45,5,CH,EQ,C' ',AND,207,2,CH,EQ,C'RE')))
INREC IFTHEN=(WHEN=(207,2,CH,EQ'RS'),
*
BUILD=(1:207,304,305:C'001',308:514,31,
338:C'COLUMBUS ',360:566,152)),CONVERT
WER161B ALTERNATE PARM USED
WER251A INCLUDE/OMIT INVALID COND
WER449I SYNCSORT GLOBAL DSM SUBSYSTEM ACTIVE


Please let me know what is going wrong with this.
Back to top
View user's profile Send private message
murmohk1

Senior Member


Joined: 29 Jun 2006
Posts: 1436
Location: Bangalore,India

PostPosted: Thu Nov 15, 2007 1:37 pm
Reply with quote

Nitin,

Quote:
WER251A INCLUDE/OMIT INVALID COND


Quote:
((45,5,CH,EQ,C'OHCOG',AND,207,2,CH,EQ,C'RS'),
OR,(45,5,CH,EQ,C'OHCOG',AND,207,2,CH,EQ,C'RW'),


You line starts with 'or'. Please code like -

Code:
((45,5,CH,EQ,C'OHCOG',AND,207,2,CH,EQ,C'RS'), OR,
(45,5,CH,EQ,C'OHCOG',AND,207,2,CH,EQ,C'RW'),
Back to top
View user's profile Send private message
murmohk1

Senior Member


Joined: 29 Jun 2006
Posts: 1436
Location: Bangalore,India

PostPosted: Thu Nov 15, 2007 1:40 pm
Reply with quote

Nitin,

icon_redface.gif ops. Wrong suggest. Ignore my prev post.

Mods,

Could you delete my prev and this posts. Thanks. icon_biggrin.gif
Back to top
View user's profile Send private message
krisprems

Active Member


Joined: 27 Nov 2006
Posts: 649
Location: India

PostPosted: Thu Nov 15, 2007 1:54 pm
Reply with quote

pjnithin
This statement should be
Code:
INREC IFTHEN=(WHEN=(207,2,CH,EQ'RS'),


Code:
INREC IFTHEN=(WHEN=(207,2,CH,EQ,C'RS'),
Back to top
View user's profile Send private message
pjnithin

Active User


Joined: 22 Dec 2005
Posts: 116

PostPosted: Thu Nov 15, 2007 2:06 pm
Reply with quote

Thanks for that....
But now I am getting a different error, it is not taking the convert verb.
The message I am getting is :
SYSIN :
SORT FIELDS=(COPY),EQUALS
INCLUDE COND=((5,5,CH,EQ,C'36308'),AND,
((45,5,CH,EQ,C'OHCOG',AND,207,2,CH,EQ,C'RS'),
OR,(45,5,CH,EQ,C'OHCOG',AND,207,2,CH,EQ,C'RW'),
OR,(45,5,CH,EQ,C'OHCO1',AND,207,2,CH,EQ,C'RS'),
OR,(45,5,CH,EQ,C'OHCO1',AND,207,2,CH,EQ,C'RW'),
OR,(45,5,CH,EQ,C' ',AND,207,2,CH,EQ,C'RE')))
OUTREC IFTHEN=(WHEN=(207,2,CH,EQ,C'RS'),
BUILD=(1:207,304,305:C'001',308:514,31,
338:C'COLUMBUS ',360:566,152)),CONVERT
*
WER161B ALTERNATE PARM USED
WER268A OUTREC STATEMENT : SYNTAX ERROR
WER449I SYNCSORT GLOBAL DSM SUBSYSTEM ACTIVE
Back to top
View user's profile Send private message
Aaru

Senior Member


Joined: 03 Jul 2007
Posts: 1287
Location: Chennai, India

PostPosted: Thu Nov 15, 2007 2:18 pm
Reply with quote

Pjnithin,

I doubt whether CONVERT verb can be used to convert VB to FB.
Back to top
View user's profile Send private message
Aaru

Senior Member


Joined: 03 Jul 2007
Posts: 1287
Location: Chennai, India

PostPosted: Thu Nov 15, 2007 2:27 pm
Reply with quote

Yes, CONVERT verb can be used to convert VB to FB. Found this topic

http://ibmmainframes.com/viewtopic.php?t=24577&highlight=convert+syncsort

I guess the problem is with the SYNCSORT version as there is nothing wrong with the SORT card.
Back to top
View user's profile Send private message
krisprems

Active Member


Joined: 27 Nov 2006
Posts: 649
Location: India

PostPosted: Thu Nov 15, 2007 2:47 pm
Reply with quote

change your OUTREC to OUTFIL, and give a try
Back to top
View user's profile Send private message
pjnithin

Active User


Joined: 22 Dec 2005
Posts: 116

PostPosted: Thu Nov 15, 2007 3:23 pm
Reply with quote

With OUTFIL i think it was working, but now gave a different error.

SYSIN :
SORT FIELDS=(COPY),EQUALS
INCLUDE COND=((5,5,CH,EQ,C'36308'),AND,
((45,5,CH,EQ,C'OHCOG',AND,207,2,CH,EQ,C'RS'),
OR,(45,5,CH,EQ,C'OHCOG',AND,207,2,CH,EQ,C'RW'),
OR,(45,5,CH,EQ,C'OHCO1',AND,207,2,CH,EQ,C'RS'),
OR,(45,5,CH,EQ,C'OHCO1',AND,207,2,CH,EQ,C'RW'),
OR,(45,5,CH,EQ,C' ',AND,207,2,CH,EQ,C'RE')))
OUTFIL IFTHEN=(WHEN=(207,2,CH,EQ,C'RS'),
BUILD=(1:207,304,305:C'001',308:514,30,
338:C'COLUMBUS ',360:566,152)),CONVERT
WER161B ALTERNATE PARM USED
WER276B SYSDIAG= 17316, 384029, 384029, 2727206
WER164B 12,816K BYTES OF VIRTUAL STORAGE AVAILABLE, MAX-16K BYTES REQUESTED,
WER164B 12K BYTES RESERVE REQUESTED, 1,012K BYTES USED
WER146B 12K BYTES OF EMERGENCY SPACE ALLOCATED
WER108I SORTIN : RECFM=VB ; LRECL= 19065; BLKSIZE= 27998
WER425A CONVERT FEATURE CANNOT BE USED WITH OVERLAY OR IFTHEN
WER449I SYNCSORT GLOBAL DSM SUBSYSTEM ACTIVE



It say CONVERT feature cannot be used with IFTHEN or OVERLAY.
Back to top
View user's profile Send private message
krisprems

Active Member


Joined: 27 Nov 2006
Posts: 649
Location: India

PostPosted: Thu Nov 15, 2007 3:28 pm
Reply with quote

change ur statement like this
Code:
OUTREC IFTHEN=(WHEN=(207,2,CH,EQ,C'RS'),
BUILD=(1:207,304,305:C'001',308:514,31,
338:C'COLUMBUS ',360:566,152))
OUTFIL CONVERT
Back to top
View user's profile Send private message
pjnithin

Active User


Joined: 22 Dec 2005
Posts: 116

PostPosted: Thu Nov 15, 2007 4:01 pm
Reply with quote

Thats giving the previous error
OUTREC- SYNTAX ERROR

Anyways I am doing it in 2 steps, its working.
Thanks for your help.
Back to top
View user's profile Send private message
Aaru

Senior Member


Joined: 03 Jul 2007
Posts: 1287
Location: Chennai, India

PostPosted: Thu Nov 15, 2007 4:04 pm
Reply with quote

Pjnithin,

Good that it is working. Could you please post the final working JCL?
Back to top
View user's profile Send private message
krisprems

Active Member


Joined: 27 Nov 2006
Posts: 649
Location: India

PostPosted: Thu Nov 15, 2007 4:04 pm
Reply with quote

Quote:
Anyways I am doing it in 2 steps, its working.
Thanks for your help.
if you could show the error message, could help you in solving the problem in single step.
Back to top
View user's profile Send private message
pjnithin

Active User


Joined: 22 Dec 2005
Posts: 116

PostPosted: Thu Nov 15, 2007 4:11 pm
Reply with quote

This is the error I got.
SYSIN :
SORT FIELDS=(COPY),EQUALS
*
INCLUDE COND=((5,5,CH,EQ,C'36308'),AND,
((45,5,CH,EQ,C'OHCOG',AND,207,2,CH,EQ,C'RS'),
OR,(45,5,CH,EQ,C'OHCOG',AND,207,2,CH,EQ,C'RW'),
OR,(45,5,CH,EQ,C'OHCO1',AND,207,2,CH,EQ,C'RS'),
OR,(45,5,CH,EQ,C'OHCO1',AND,207,2,CH,EQ,C'RW'),
OR,(45,5,CH,EQ,C' ',AND,207,2,CH,EQ,C'RE')))
OUTREC IFTHEN=(WHEN=(207,2,CH,EQ,C'RS'),
BUILD=(1:207,304,305:C'001',308:514,30,
338:C'COLUMBUS ',360:566,152)),
*
OUTFIL CONVERT
WER161B ALTERNATE PARM USED
WER275A NO KEYWORDS FOUND ON CONTROL STATEMENT
WER268A OUTREC STATEMENT : SYNTAX ERROR
WER449I SYNCSORT GLOBAL DSM SUBSYSTEM ACTIVE


this is the message I got.
Back to top
View user's profile Send private message
krisprems

Active Member


Joined: 27 Nov 2006
Posts: 649
Location: India

PostPosted: Thu Nov 15, 2007 4:14 pm
Reply with quote

in the last line
Code:
338:C'COLUMBUS ',360:566,152)),
*
you have left a comma(,) as it is....
that is your syntax error
Back to top
View user's profile Send private message
murmohk1

Senior Member


Joined: 29 Jun 2006
Posts: 1436
Location: Bangalore,India

PostPosted: Thu Nov 15, 2007 4:21 pm
Reply with quote

KrisPrems,

Check this.
Quote:
338:C'COLUMBUS ',360:566,152)),
*
OUTFIL CONVERT
Back to top
View user's profile Send private message
pjnithin

Active User


Joined: 22 Dec 2005
Posts: 116

PostPosted: Thu Nov 15, 2007 4:43 pm
Reply with quote

Even without comma I was getting some error, thats why I tried with comma.

SYSIN :
SORT FIELDS=(COPY),EQUALS
*
INCLUDE COND=((5,5,CH,EQ,C'36308'),AND,
((45,5,CH,EQ,C'OHCOG',AND,207,2,CH,EQ,C'RS'),
OR,(45,5,CH,EQ,C'OHCOG',AND,207,2,CH,EQ,C'RW'),
OR,(45,5,CH,EQ,C'OHCO1',AND,207,2,CH,EQ,C'RS'),
OR,(45,5,CH,EQ,C'OHCO1',AND,207,2,CH,EQ,C'RW'),
OR,(45,5,CH,EQ,C' ',AND,207,2,CH,EQ,C'RE')))
OUTREC IFTHEN=(WHEN=(207,2,CH,EQ,C'RS'),
BUILD=(1:207,304,305:C'001',308:514,30,
338:C'COLUMBUS ',360:566,152))
OUTFIL CONVERT
*
WER161B ALTERNATE PARM USED
WER275A NO KEYWORDS FOUND ON CONTROL STATEMENT
WER275A NO KEYWORDS FOUND ON CONTROL STATEMENT
WER449I SYNCSORT GLOBAL DSM SUBSYSTEM ACTIVE

This was what I was getting without comma, any idea whats wrong???
Back to top
View user's profile Send private message
krisprems

Active Member


Joined: 27 Nov 2006
Posts: 649
Location: India

PostPosted: Thu Nov 15, 2007 4:46 pm
Reply with quote

what is the LRECL of your o/p FB file?
Back to top
View user's profile Send private message
krisprems

Active Member


Joined: 27 Nov 2006
Posts: 649
Location: India

PostPosted: Thu Nov 15, 2007 5:18 pm
Reply with quote

OK, whatever is your LRECL, just replace it in the below statement
Code:
OUTFIL OUTREC=(1,LRECL),CONVERT
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 Syncsort help SYNCSORT 3
No new posts SYNCSORT-DB2 interface SYNCSORT 0
No new posts To Omit records based n SORT condition DFSORT/ICETOOL 6
No new posts INCLUDE OMIT COND for Multiple values... DFSORT/ICETOOL 5
Search our Forums:

Back to Top