|
|
| Author |
Message |
srj1957
Active User
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 |
|
| Back to top |
|
 |
References
|
 Posted: Wed Jul 09, 2008 12:25 am Post subject: Re: Multiple output file problem |
|
|
|
|
Skolusu
DFSORT Developer
Joined: 07 Dec 2007
Posts: 314
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')
//*
|
|
|
| Back to top |
|
|
Frank Yaeger
DFSORT Moderator
Joined: 15 Feb 2005
Posts: 4414
Location: San Jose, CA
|
|
|
|
| Quote: |
| I've searched the forum and it looks like I'm coding it correctly |
Not even close. 
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. |
|
| Back to top |
|
|
srj1957
Active User
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.
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...  |
|
| Back to top |
|
|
|
|
|
