How to break up a LARGE physical file

I have a client that has a 12 million rec pf that he wants to
break-up into smaller files, BUT there's a catch, he doesn't want
to make any changes to his apps.

Basically he wants to divide his data by year, and requires both
lookup and update of ANY record. He had tried breaking the file
up and then using logicals with joins to see the whole base when
required. Lookups are fine but updates die. He didn't have the msg
handy when he called just something about not being allowed.

DB programming is not my strong point, so if I left anything
important out feel free to ask and as always any and all comments
welcome.

thx  
-- 
Kirk Goins
DecisionOne - Portland, OR
EMAIL kgoins@ix.netcom.com              
      71445.1231@compuserve.com
root
* * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * *
* This is the Midrange System Mailing List!  To submit a new message,   *
* send your mail to "MIDRANGE-L@midrange.com".  To unsubscribe from     *
* this list send email to MAJORDOMO@midrange.com and specify            *
* 'unsubscribe MIDRANGE-L' in the body of your message.  Questions      *
* should be directed to the list owner / operator: david@midrange.com   *
* * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * *