Portal | Manuals | References | Downloads | Info | Programs | JCLs | Mainframe wiki | Quick Ref
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
 
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 query to fetch record which has only ... maxsubrat DB2 3 Mon Dec 11, 2017 5:03 pm
No new posts File Tailoring -- Temporary dataset i... samzee71 CLIST & REXX 3 Fri Dec 01, 2017 3:12 am
No new posts Rexx - File tailoring samzee71 CLIST & REXX 10 Thu Nov 30, 2017 10:47 pm
No new posts Extract record for change in combinat... Trinadh DFSORT/ICETOOL 6 Thu Nov 23, 2017 3:32 pm
No new posts Moving a PS file as body of a mail! Vignesh Sid JCL & VSAM 4 Tue Nov 21, 2017 9:23 pm

Facebook
Back to Top
 
Job Vacancies | Forum Rules | Bookmarks | Subscriptions | FAQ | Polls | Contact Us