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
 

 

splitting the large file using File-Aid.

 
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> Mainframe Interview Questions
View previous topic :: :: View next topic  
Author Message
mf_user
Currently Banned

New User


Joined: 05 Jan 2006
Posts: 47

PostPosted: Tue Mar 07, 2006 5:41 pm    Post subject: splitting the large file using File-Aid.
Reply with quote

Hi,

I faced this question during an interview.

How to split a file into multiple files using FILE-AID? The input file has got 10,00,000 records. First two output files should have 4,00,000 records and last output file should have 2,00,000 records.

How to achieve it using File-Aid only? icon_eek.gif

Thanks a lot in advance.
Back to top
View user's profile Send private message

Gautam512

Active User


Joined: 05 Oct 2005
Posts: 309
Location: Vizag / US

PostPosted: Wed Mar 29, 2006 6:07 pm    Post subject: Re: splitting the large file using File-Aid.
Reply with quote

Hi,

This can be done thru JCL using File-Aid , if u need it i'll post the JCL.
Back to top
View user's profile Send private message
mf_user
Currently Banned

New User


Joined: 05 Jan 2006
Posts: 47

PostPosted: Wed Mar 29, 2006 6:53 pm    Post subject:
Reply with quote

Gautam512,

Please post the JCL.

TIA.
Back to top
View user's profile Send private message
Gautam512

Active User


Joined: 05 Oct 2005
Posts: 309
Location: Vizag / US

PostPosted: Thu Mar 30, 2006 7:52 pm    Post subject: Re: splitting the large file using File-Aid.
Reply with quote

Hi,

Here is the JCL

Code:
//  --- - -       Job Card -------
//*                                                     
//*-----------------------------------------------------
//FILEAID  EXEC PGM=FILEAID         
//*                                 
//SYSIN    DD *                     
                                 
$$DD01     USER OUT=num of records,WRITE=FILE1
$$DD01     USER OUT=num of records,WRITE=FILE2
$$DD01     USER OUT=num of records,WRITE=FILE3

//DD01     DD DSN=INPUT.DATASET,DISP=SHR
//FILE1    DD DISP=(NEW,CATLG,DELETE),               
//            UNIT=TMSPROD,SPACE=(CYL,(20,10),RLSE),
//            DCB=*.DD01,                           
//            DSN=DATASET.OUT1                             
//*                                                 
//FILE2    DD DISP=(NEW,CATLG,DELETE),               
//            UNIT=TMSPROD,SPACE=(CYL,(200,10),RLSE),
//            DCB=*.DD01,                           
//            DSN=DATASET.OUT2                             
//FILE3    DD DISP=(NEW,CATLG,DELETE),               
//            UNIT=TMSPROD,SPACE=(CYL,(200,10),RLSE),
//            DCB=*.DD01,                           
//            DSN=DATASET.OUT3                             
//*
//* For how many output file , so many output dataset steps
//* End JCL
Back to top
View user's profile Send private message
Gautam512

Active User


Joined: 05 Oct 2005
Posts: 309
Location: Vizag / US

PostPosted: Fri Mar 31, 2006 11:19 am    Post subject: Re: splitting the large file using File-Aid.
Reply with quote

Hi mf_user,

did u try the jcl , did u got ur expected results,

let me know if there is any problem.....
Back to top
View user's profile Send private message
ameetmund

New User


Joined: 02 Jun 2006
Posts: 6

PostPosted: Fri Jun 02, 2006 10:05 am    Post subject: Re: splitting the large file using File-Aid.
Reply with quote

Hi,

Its very easy to split a file using file-aid. No need to write any JCL for that icon_biggrin.gif
Just follow the following process to split a file

1) go to option 3.3 in file aid
2) specify your from and to file name
3) Then give selection criteria usage as 'T'
4) Then it will take you to the next screen where it will have 3 options
5) choose the first one 'OPTION'
6) Then in the following screen u can have your own criteria to select records e.g forward or backward, no of records to skip, no of records to select etc....

File-AID -------------- Selection Criteria Options ------------------------
COMMAND ===>

Specify Selection Criteria Options:
Start at the following record key
(both blank for start of dataset)
Starting record key ===>
- OR - OR at the following RBA or RRN
Starting RBA or RRN ===>

Initial records to skip ===> 0 then skip this many records

Subsequent Selection Interval: then repeat the following
Records to select ===> 1 - select this many records
Records to skip ===> 0 - then skip this many records
until
Number of records to search ===> ALL you have read this many records
Number of records to select ===> ALL or selected this many records

SEQ/VSAM processing direction ===> F (F = Forward; B = Backward)


Use ENTER to return to selection criteria menu


I think it will solve your problem......if u have any problem feel free to ask

Amit
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 -> Mainframe Interview Questions All times are GMT + 6 Hours
Page 1 of 1

 

Search our Forum:

Similar Topics
Topic Author Forum Replies Posted
No new posts SORTJOIN - Copy Matched and Unmatched... Steve Ironmonger DFSORT/ICETOOL 5 Tue Jan 17, 2017 4:26 pm
No new posts Copy RECFM =VB TO FB file with RECL =... sahil41352 DFSORT/ICETOOL 3 Wed Dec 28, 2016 11:29 pm
No new posts Add PD field from 2nd file to PD in 1st Sushant Garje DFSORT/ICETOOL 6 Thu Dec 01, 2016 4:32 pm
No new posts File Aid to File Manager conversion murali3955 IBM Tools 4 Thu Nov 24, 2016 3:41 pm
No new posts How to convert the VBM file to VB or... Sulabh Agrawal JCL & VSAM 4 Fri Nov 18, 2016 1:04 pm


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