flat-file insert question

From: Leegold (leegold_at_fastmail.fm)
Date: 05/17/04 

To: dbi-users@perl.org
Date: Mon, 17 May 2004 11:23:56 -0400

Given a flat-file:

1###A###703
2###D###203
3###E###303
4###J###901

The file is sorted by field2. Field1 (the numbers) is
dependent on the "position" of the record after it's
sorted by field2. Say I wanted to insert a rec. w/field2=C.

I'm using AnyData, so I can use SQL commands on the file.
What's the best strategy to do an insert? I could just append
a record, then do a sort on field2 (eg. unix sort command),
and then perl process to get field1 right. But,
Is the an SQl type way? Or a cleaner way?

Thanks,
Lee 

-- 
http://www.fastmail.fm - Does exactly what it says on the tin