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
 

 

INSERTING A NEW RECORD IN FILE AID

 
Post new topic   Reply to topic    IBMMAINFRAMES.com Support Forums -> Compuware & Other Tools
View previous topic :: :: View next topic  
Author Message
umakanth.ravirala

New User


Joined: 04 Sep 2007
Posts: 15
Location: Halifax, United Kingdom

PostPosted: Tue Nov 20, 2007 1:28 pm    Post subject: INSERTING A NEW RECORD IN FILE AID
Reply with quote

Hi,
Iam a new user to FILE AID
I want to edit a PS which is having more than 3 million records
I choose FILE AID to do that.
Please let me know how to add new record(what is the option to add a new record) through FILE AID
Back to top
View user's profile Send private message

Devzee

Active Member


Joined: 20 Jan 2007
Posts: 684
Location: Hollywood

PostPosted: Tue Nov 20, 2007 8:15 pm    Post subject:
Reply with quote

If the file is huge, you wont be able to edit the file.

Since you are trying to ADD and not CHANGE, What you can do is create a file with those new records that you want to add, and then append to ur Master file.
Back to top
View user's profile Send private message
cpuhawg

Active User


Joined: 14 Jun 2006
Posts: 331
Location: Jacksonville, FL

PostPosted: Wed Nov 21, 2007 12:18 am    Post subject: Reply to: INSERTING A NEW RECORD IN FILE AID
Reply with quote

If you have 3 million records, you will need to execute FILEAID in batch.

With batch FILEAID, you can use the USER option to add records.

Code:

//FILEAID EXEC PGM=FILEAID                                           
//SYSPRINT DD  SYSOUT=*                                               
//DD01     DD DISP=SHR,DSN=HLQ.UINPUT.FILE             
//DD01O    DD DSN=HLQ.OUTPUT FILEE,                 
//            DISP=(NEW,CATLG),                                       
//            UNIT=(SYSDA),SPACE=(TRK,(500,50),RLSE),                 
//            DCB=(RECFM=FB,LRECL=80,BLKSIZE=27920)                   
//SYSIN    DD  *                                                     
$$DD01 USER PADCHAR=C' ', 
       IF=(1.NE.C'????'),WRITE=DD01O,
       IF=(1,EQ,C'????'),MOVE=(1,8,10),MOVE=(9,C' '),
       MOVE=(10,3,135),WRITE=DD01O,       
       IF=(1,EQ,C'????'),MOVE=(1,8,10),MOVE=(9,C'X'),
       MOVE=(10,3,135),WRITE=DD01O                           
/*
 



Use an IF parameter to select some criteria, then build your records and issue the WRITE=DD01O parameter to OUTPUT the records.
The above criteria will write two records for every one record that matches the IF= parameter.
Back to top
View user's profile Send private message
umakanth.ravirala

New User


Joined: 04 Sep 2007
Posts: 15
Location: Halifax, United Kingdom

PostPosted: Wed Nov 21, 2007 2:34 pm    Post subject: Reply to: INSERTING A NEW RECORD IN FILE AID
Reply with quote

thank you for provididng me the solution
i used sort to append new records to the master file and it is working fine
thanks a lot
Back to top
View user's profile Send private message
murmohk1

Senior Member


Joined: 29 Jun 2006
Posts: 1439
Location: Bangalore,India

PostPosted: Thu Nov 22, 2007 9:21 am    Post subject:
Reply with quote

Devzee,

Quote:
If the file is huge, you wont be able to edit the file.

Its not true.

Please note that I had 'edited' a file with 8.8M records (though this is not recomended).
Back to top
View user's profile Send private message
Devzee

Active Member


Joined: 20 Jan 2007
Posts: 684
Location: Hollywood

PostPosted: Thu Nov 22, 2007 12:35 pm    Post subject:
Reply with quote

huge file - depends on how we interpret this size (say if it is more than a GB then we cant edit)
Back to top
View user's profile Send private message
umakanth.ravirala

New User


Joined: 04 Sep 2007
Posts: 15
Location: Halifax, United Kingdom

PostPosted: Fri Nov 23, 2007 12:12 pm    Post subject: Reply to: INSERTING A NEW RECORD IN FILE AID
Reply with quote

yes the size of the file is very high
any have i got it using SORT
thanks all for replying.... icon_smile.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 -> Compuware & Other Tools 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