Syncsort problem INCLUDE/OMIT INVALID COND

pjnithin · Active User Joined: 22 Dec 2005 Posts: 116

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.

murmohk1 · Posted: Thu Nov 15, 2007 1:37 pm

Nitin,

murmohk1 · Posted: Thu Nov 15, 2007 1:40 pm

Nitin,

ops. Wrong suggest. Ignore my prev post.

Mods,

Could you delete my prev and this posts. Thanks.

krisprems · Posted: Thu Nov 15, 2007 1:54 pm

pjnithin
This statement should be

pjnithin · Active User Joined: 22 Dec 2005 Posts: 116

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

Aaru · Posted: Thu Nov 15, 2007 2:18 pm

Pjnithin,

I doubt whether CONVERT verb can be used to convert VB to FB.

Aaru · Posted: Thu Nov 15, 2007 2:27 pm

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.

krisprems · Posted: Thu Nov 15, 2007 2:47 pm

change your OUTREC to OUTFIL, and give a try

pjnithin · Active User Joined: 22 Dec 2005 Posts: 116

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.

krisprems · Posted: Thu Nov 15, 2007 3:28 pm

change ur statement like this

pjnithin · Active User Joined: 22 Dec 2005 Posts: 116

Thats giving the previous error
OUTREC- SYNTAX ERROR

Anyways I am doing it in 2 steps, its working.
Thanks for your help.

Aaru · Posted: Thu Nov 15, 2007 4:04 pm

Pjnithin,

Good that it is working. Could you please post the final working JCL?

krisprems · Posted: Thu Nov 15, 2007 4:04 pm

pjnithin · Active User Joined: 22 Dec 2005 Posts: 116

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.

krisprems · Posted: Thu Nov 15, 2007 4:14 pm

in the last line

murmohk1 · Posted: Thu Nov 15, 2007 4:21 pm

KrisPrems,

Check this.

pjnithin · Active User Joined: 22 Dec 2005 Posts: 116

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???

krisprems · Posted: Thu Nov 15, 2007 4:46 pm

what is the LRECL of your o/p FB file?

krisprems · Posted: Thu Nov 15, 2007 5:18 pm

OK, whatever is your LRECL, just replace it in the below statement