MVSFORUMS.com

nadh · Intermediate Joined: 08 Oct 2004 Posts: 192 Topics: 89

Hi,

I have a file which is having 300,000 records. I need to update one record in that. If i try to open that file in edit mode its automaticaly going to browse mode. Its same even if I try in File-Aid too. Pls. let me know how can I do that.

Cheers!!!
Nadh

kolusu · Posted: Tue Jun 27, 2006 8:24 am Post subject:

nadh,

Why not run file-aid in batch mode to perform the update.

Kolusu
_________________
Kolusu
www.linkedin.com/in/kolusu

deepaannjohn · Beginner Joined: 28 Jun 2006 Posts: 1 Topics: 0

You can open the file using file aid and use 'selection criteria' as temporary. In the next panel, choose '1'. specify the selection criteria there.
ie you can skip 299999 records and edit the required record.

deepeshk79 · Posted: Mon Jul 03, 2006 8:03 am Post subject:

Nadh,

Say you have to modify the 900th record. Then you can can do like this.

Split your file into 3 files, the first having 899 records.
The second having only the 900th record.
The third file having the remaining records.

Modify the second file with the changes you want and then merge these together.
The above split can be achived using ICEMAN (Hope u have DFSORT installed in your installation)

kolusu · Posted: Mon Jul 03, 2006 8:20 am Post subject:

deepeshk79,

You don't need to split and merge for modifying the record. All of this can done in one simple step

for the same example you quoted here is a one step solution. If the record no is 900 then we change the contents at pos 5 to 'change'

nadh · Intermediate Joined: 08 Oct 2004 Posts: 192 Topics: 89

ThanQ Kolusu,

It worked.

Cheers!!!
Nadh