Re: 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.
>
Would creating a logical file for each year satisfy the customer's
requirements.  Updates would work through either the combined physical or
the individual logical.

I'm not sure what the problem is you are trying to address in the first
place.  Why is a 12 million record file a problem?


Charlie Massoglia, Massoglia Technical Consulting, Inc.
PO Box 1065, Okemos, MI 48854, USA
517-676-9700  Fax: 517-676-1006  EMAIL: cmassoglia@voyager.net


* * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * *
* 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   *
* * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * *