Portal | Manuals | References | Downloads | Info | Programs | JCLs | Master the Mainframes
IBM Mainframe Computers Forums Index
 
Register
 
IBM Mainframe Computers Forums Index Mainframe: Search IBM Mainframe Forum: FAQ Memberlist Profile Log in to check your private messages Log in
 
Multiple output file problem

 
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> DFSORT/ICETOOL
View previous topic :: :: View next topic  
Author Message
srj1957

New User


Joined: 15 Dec 2005
Posts: 72
Location: RALEIGH NC, USA

PostPosted: Wed Jul 09, 2008 12:25 am    Post subject: Multiple output file problem
Reply with quote

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

Skolusu

Senior Member


Joined: 07 Dec 2007
Posts: 2205
Location: San Jose

PostPosted: Wed Jul 09, 2008 12:33 am    Post subject: Reply to: Multiple output file problem
Reply with quote

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

DFSORT Moderator


Joined: 15 Feb 2005
Posts: 7130
Location: San Jose, CA

PostPosted: Wed Jul 09, 2008 12:47 am    Post subject:
Reply with quote

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


Not even close. icon_wink.gif

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

New User


Joined: 15 Dec 2005
Posts: 72
Location: RALEIGH NC, USA

PostPosted: Wed Jul 09, 2008 2:29 am    Post subject:
Reply with quote

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


Not even close. icon_wink.gif

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... icon_cool.gif
Back to top
View user's profile Send private message
View previous topic :: :: View next topic  
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> DFSORT/ICETOOL All times are GMT + 6 Hours
Page 1 of 1

 

Search our Forum:

Similar Topics
Topic Author Forum Replies Posted
No new posts LMINIT problem - not finding DDNAME Danielle.Filteau CLIST & REXX 7 Tue Sep 19, 2017 9:57 pm
No new posts ejck thru rexx to multiple jobs insid... Susanta All Other Mainframe Topics 5 Tue Sep 19, 2017 1:39 pm
No new posts Split 1 file into 10 output Files - S... Prasanth Kumar SYNCSORT 5 Sat Sep 16, 2017 12:02 am
No new posts BUILD OUTFIL based on condition other... balaji81_k DFSORT/ICETOOL 13 Fri Sep 08, 2017 11:06 pm
No new posts PLI - printing from multiple programs Pedro PL/I & Assembler 8 Fri Sep 08, 2017 6:36 am

Facebook
Back to Top
 
Mainframe Wiki | Forum Rules | Bookmarks | Subscriptions | FAQ | Tutorials | Contact Us