|
Evan, The IBM Teraplex Center has online docs on loading data, try this link. http://www.softmall.ibm.com/as400/bi/teraplex/lessons.html#load Option 1, deleting the logicals and rebuilding them is the fastest. Joel Belcher, Ohana Design Group joel@ohanagroup.com -----Original Message----- From: Evan Harris <spanner@ihug.co.nz> To: midrange-l@midrange.com <midrange-l@midrange.com> Date: Wednesday, October 14, 1998 9:01 PM Subject: Creating Logicals before or after populating a file ? > >We are about to embark on an exercise that will populate a *large* >database file (40 million records plus). This file has about 20 logical >files built over it. > >My question is, which is more efficient: > >1. Populating the file and building the logicals ? > >2. Building the logicals and populating the file ? > >Any thoughts would be greatly appreciated. > >Cheers, >Evan Harris >+--- >| This is the Midrange System Mailing List! >| To submit a new message, send your mail to MIDRANGE-L@midrange.com. >| To subscribe to this list send email to MIDRANGE-L-SUB@midrange.com. >| To unsubscribe from this list send email to MIDRANGE-L-UNSUB@midrange.com. >| Questions should be directed to the list owner/operator: david@midrange.com >+--- +--- | This is the Midrange System Mailing List! | To submit a new message, send your mail to MIDRANGE-L@midrange.com. | To subscribe to this list send email to MIDRANGE-L-SUB@midrange.com. | To unsubscribe from this list send email to MIDRANGE-L-UNSUB@midrange.com. | Questions should be directed to the list owner/operator: david@midrange.com +---
As an Amazon Associate we earn from qualifying purchases.
This mailing list archive is Copyright 1997-2024 by midrange.com and David Gibbs as a compilation work. Use of the archive is restricted to research of a business or technical nature. Any other uses are prohibited. Full details are available on our policy page. If you have questions about this, please contact [javascript protected email address].
Operating expenses for this site are earned using the Amazon Associate program and Google Adsense.