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 Usergroups Profile Log in to check your private messages Log in
 

 

SPLITBY Function in ICETOOL

 
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> JCL & VSAM
View previous topic :: :: View next topic  
Author Message
mainframe_techie

New User


Joined: 15 Jul 2007
Posts: 23
Location: India

PostPosted: Tue Jul 24, 2007 6:00 am    Post subject: SPLITBY Function in ICETOOL
Reply with quote

Hi,

I am trying to split a file into 5 files.
I am using SPLITBY function.
Here are the sample input file records:

<T> BEST1 <T
<T> BEST2 <T>
<T> TEST <T>
<T> TEST1 <T>
<T> TEST1 <T>
<T> TEST1 <T>
<T> TEST1 <T>
<T> TEST1 <T>

The out put file have :
O/P 1 is :

<T> BEST1 <T>
<T> TEST1 <T>

O/P 2 is :

<T> BEST2 <T>
<T> TEST1 <T>

and so on.

The sort card is

//TOOLIN DD *
COPY FROM(DETAILS) USING(CTL1)
/*
//*
//CTL1CNTL DD *
OUTFIL FNAMES=(FILE2,FILE3,FILE4,FILE5,FILE6),SPLITBY=1

Actually I need 1 record in each file. Can anybody please let me know why this is happeing and how can I acheive what I need ??

Thanks,
mainframe_techie
Back to top
View user's profile Send private message

dick scherrer

Site Director


Joined: 23 Nov 2006
Posts: 19270
Location: Inside the Matrix

PostPosted: Tue Jul 24, 2007 6:30 am    Post subject:
Reply with quote

Hello,

You need to post better examples.

Create a wider variety of input data and more than 8 records. Make sure that the records are not just repeats - the way you have defined the data causes confusion when you look at the output. Also make sure that there are no typo's - i believe your first test record is missing the ending ">".

If you only put 1 record in each output file, what about the records that are "left over"?

I believe the reason you see the output you are seeing is because the splitby you specified puts 1 record in each output file and then starts again at file 1. This continues in rotation until all of the input has been copied into the 6 output files.
Back to top
View user's profile Send private message
krisprems

Active Member


Joined: 27 Nov 2006
Posts: 649
Location: India

PostPosted: Tue Jul 24, 2007 2:01 pm    Post subject:
Reply with quote

mainframe_techie

Look at the Split a file to n output files dynamically and Five ways to split a data set Smart DFSORT Tricks at

http://www.ibm.com/servers/storage/support/software/sort/mvs/tricks/

Iin case you need any help:
1. then post the sample set of i/ps with the record numbers, and which record should go to which o/p file?
meant to say,do you want to split the i/p based on any rule?
2. You want to split in to how many o/p file's
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 -> JCL & VSAM All times are GMT + 6 Hours
Page 1 of 1

 

Search our Forum:

Similar Topics
Topic Author Forum Replies Posted
No new posts Using ICETOOL, how we can seperate th... bshkris SYNCSORT 5 Tue May 09, 2017 8:33 pm
No new posts Group elements using ICETOOL Learncoholic DFSORT/ICETOOL 2 Fri Apr 14, 2017 11:01 am
No new posts Converting decimal to numeric using I... Balaryan DFSORT/ICETOOL 4 Thu Feb 02, 2017 11:27 pm
This topic is locked: you cannot edit posts or make replies. RANDOM Function in COBOL swapnil781 COBOL Programming 2 Tue Nov 15, 2016 6:17 pm
No new posts Check System time(Minute) Using TIME1... balaji81_k DFSORT/ICETOOL 5 Fri Nov 11, 2016 10:53 am


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