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 Compare yesterday's date to the one o... migusd SYNCSORT 1 Fri Sep 22, 2017 11:35 pm
No new posts Split 1 file into 10 output Files - S... Prasanth Kumar SYNCSORT 5 Sat Sep 16, 2017 12:02 am
No new posts BUILD OUTFIL based on condition other... balaji81_k DFSORT/ICETOOL 13 Fri Sep 08, 2017 11:06 pm
No new posts Updating the Trailer count in variabl... satheshbabur DFSORT/ICETOOL 6 Wed Aug 30, 2017 9:49 pm
No new posts Skip file from delete pema_yozer All Other Mainframe Topics 3 Tue Aug 29, 2017 3:19 pm

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