IBM MAINFRAME HELP FORUMS for COBOL, JCL, CICS, DB2, IMS etc...

srj1957 · Joined: 15 Dec 2005 Posts: 53 Location: RALEIGH NC, USA

:!:
I am geting an error when trying to spilt 1 file into multiple using the following syntax..I've searched the forum and it looks like I'm coding it correctly..maybe a new set of eyes can spot what I'm doing wrong

Code:
//SORT1 EXEC SORT
//SORTIN DD DSN=ISD.SRJ.DBLABMAL.EXTR,DISP=SHR
//*
//OUT1 DD DSN=DB2.DB21.DBLABMAL.FILE1,
...
//OUT2 DD DSN=DB2.DB21.DBLABMAL.FILE2,
...
//OUT3 DD DSN=DB2.DB21.DBLABMAL.FILE3,
...
//SYSIN DD *
SORT FIELDS=COPY
OUTFIL FNAMES=OUT1
INCLUDE COND=(8,4,CH,EQ,C'2013',OR,
8,4,CH,EQ,C' 77',OR,
8,4,CH,EQ,C'1769',OR,
8,4,CH,EQ,C'2014')
OUTFIL FNAMES=OUT2
INCLUDE COND=(8,4,CH,EQ,C' 715',OR,
8,4,CH,EQ,C' 714',OR,
8,4,CH,EQ,C'1735')
OUTFIL FNAMES=OUT3
INCLUDE COND=(8,4,CH,EQ,C' 240',OR,
8,4,CH,EQ,C' 238',OR,
8,4,CH,EQ,C' 236')
//

This is the DFSORT error

Code:
ICE143I 0 BLOCKSET COPY TECHNIQUE SELECTED
ICE250I 0 VISIT http://www.ibm.com/storage/dfsort FOR DFSORT PAPERS, EXAMPLES AN
ICE000I 1 - CONTROL STATEMENTS FOR 5694-A01, Z/OS DFSORT V1R5 - 14:48 ON TUE JUL

SORT FIELDS=COPY
OUTFIL FNAMES=OUT1
INCLUDE COND=(8,4,CH,EQ,C'2013',OR,
8,4,CH,EQ,C' 77',OR,
8,4,CH,EQ,C'1769',OR,
8,4,CH,EQ,C'2014')
OUTFIL FNAMES=OUT2
INCLUDE COND=(8,4,CH,EQ,C' 715',OR,
ICE002I 0 DUPLICATE OR CONFLICTING INCLUDE STATEMENT
8,4,CH,EQ,C' 714',OR,
$
ICE007A 0 SYNTAX ERROR
8,4,CH,EQ,C'1735')
$
ICE007A 0 SYNTAX ERROR
OUTFIL FNAMES=OUT3
INCLUDE COND=(8,4,CH,EQ,C' 240',OR,
ICE002I 0 DUPLICATE OR CONFLICTING INCLUDE STATEMENT
8,4,CH,EQ,C' 238',OR,
$
ICE007A 0 SYNTAX ERROR
8,4,CH,EQ,C' 236')
$
ICE007A 0 SYNTAX ERROR
ICE751I 0 C5-K05352 C6-Q95214 C7-K90000 C8-K05352 E7-K90000
ICE052I 3 END OF DFSORT

Thanks in advance for any suggestions

Skolusu · Joined: 07 Dec 2007 Posts: 296 Location: San Jose

You should only use INCLUDE and not INCLUDE COND on OUTFIL. Try these DFSORT control cards

Code:
/SYSIN DD *
SORT FIELDS=COPY
OUTFIL FNAMES=OUT1,
INCLUDE=(8,4,CH,EQ,C'2013',OR,
8,4,CH,EQ,C' 77',OR,
8,4,CH,EQ,C'1769',OR,
8,4,CH,EQ,C'2014')

OUTFIL FNAMES=OUT2,
INCLUDE=(8,4,CH,EQ,C' 715',OR,
8,4,CH,EQ,C' 714',OR,
8,4,CH,EQ,C'1735')

OUTFIL FNAMES=OUT3,
INCLUDE=(8,4,CH,EQ,C' 240',OR,
8,4,CH,EQ,C' 238',OR,
8,4,CH,EQ,C' 236')
//*

Frank Yaeger · Joined: 15 Feb 2005 Posts: 4355 Location: San Jose, CA

Quote: I've searched the forum and it looks like I'm coding it correctly

Not even close. :wink:

You are intermixing OUTFIL statements and INCLUDE statements. You can have multiple OUTFIL statements, each with its own INCLUDE operand (as Kolusu shows), but you can't have multiple INCLUDE statements.

srj1957 · Joined: 15 Dec 2005 Posts: 53 Location: RALEIGH NC, USA

Frank Yaeger wrote: Quote: I've searched the forum and it looks like I'm coding it correctly

Not even close. :wink:

You are intermixing OUTFIL statements and INCLUDE statements. You can have multiple OUTFIL statements, each with its own INCLUDE operand (as Kolusu shows), but you can't have multiple INCLUDE statements.

Thanks everyone, it works like a charm ...I didn't even notice that... I think I'm going blind... --)