View previous topic :: View next topic
|
Author |
Message |
umakanth.ravirala
New User
Joined: 04 Sep 2007 Posts: 15 Location: Halifax, United Kingdom
|
|
|
|
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 |
|
|
Devzee
Active Member
Joined: 20 Jan 2007 Posts: 684 Location: Hollywood
|
|
|
|
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 |
|
|
cpuhawg
Active User
Joined: 14 Jun 2006 Posts: 331 Location: Jacksonville, FL
|
|
|
|
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 |
|
|
umakanth.ravirala
New User
Joined: 04 Sep 2007 Posts: 15 Location: Halifax, United Kingdom
|
|
|
|
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 |
|
|
murmohk1
Senior Member
Joined: 29 Jun 2006 Posts: 1436 Location: Bangalore,India
|
|
|
|
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 |
|
|
Devzee
Active Member
Joined: 20 Jan 2007 Posts: 684 Location: Hollywood
|
|
|
|
huge file - depends on how we interpret this size (say if it is more than a GB then we cant edit) |
|
Back to top |
|
|
umakanth.ravirala
New User
Joined: 04 Sep 2007 Posts: 15 Location: Halifax, United Kingdom
|
|
|
|
yes the size of the file is very high
any have i got it using SORT
thanks all for replying.... |
|
Back to top |
|
|
|