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

SPLIT the Records


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

New User


Joined: 26 Oct 2007
Posts: 4
Location: chennai

PostPosted: Wed Jul 02, 2008 11:23 am
Reply with quote

If i have a file, which contains four records I would like to split the 4 different outputs for each record how to do?

Can anyone explain me?
Back to top
View user's profile Send private message
Vasukip
Currently Banned

New User


Joined: 17 Jun 2008
Posts: 48
Location: Chennai

PostPosted: Wed Jul 02, 2008 11:51 am
Reply with quote

Hi,
Try ds Code !
Code:

//STEPLIB EXEC PGM=SORT                       
//SORTIN DD *                                 
AAA   123      401                             
AAA   456      401                             
BBB   987      411                             
BBB   123      411                             
/*                                             
//OUT1 DD DSN=Output File1,DISP=SHR     
//OUT2 DD DSN=Output File2,DISP=SHR     
//OUT3 DD DSN=Output File3,DISP=SHR     
//OUT4 DD DSN=Output File4,DISP=SHR
//SYSIN DD *                                       
  SORT FIELDS=COPY                                 
  OUTFIL FNAMES=(OUT1,OUT2,OUT3,OUT4),SPLITBY=1   
/*                                                 
//SYSPRINT DD SYSOUT=*                             
//SYSOUT   DD SYSOUT=*                             
//                                                     


SPLITBY=N , 'n' no of records will be splited in to output Files.
Back to top
View user's profile Send private message
boobalamurugan

New User


Joined: 26 Oct 2007
Posts: 4
Location: chennai

PostPosted: Wed Jul 02, 2008 12:00 pm
Reply with quote

Its working fine vasukip.
Back to top
View user's profile Send private message
Vasukip
Currently Banned

New User


Joined: 17 Jun 2008
Posts: 48
Location: Chennai

PostPosted: Wed Jul 02, 2008 12:05 pm
Reply with quote

yw icon_razz.gif !
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 How to split large record length file... DFSORT/ICETOOL 10
No new posts Compare only first records of the fil... SYNCSORT 7
No new posts Pulling a fixed number of records fro... DB2 2
No new posts Join multiple records using splice DFSORT/ICETOOL 5
No new posts EZT program to build a flat file with... All Other Mainframe Topics 9
Search our Forums:

Back to Top