Hey Gary, As you know, it is possible to import the files into Access, which may be your best bet, depending on the size and what you're trying to do. If your client is going to be exploring the data in a lot of different ways, and the iSeries is already pretty loaded, that would be a good time to consider importing the data. I've used Access 2000 as a local data mining tool with databases well over 1GB/1 million records, and it performs fine on a buff PC (lots of ram and a fast HD setup). If you can import to a local db, users can query all they want without affecting the AS/400 performance. Otherwise, it could have a big impact, depending on your database size and structure and AS/400's capacity. You can automate it with VBA code or a macro. For macros, run the "TransferDatabase" command. For the database type, choose ODBC, then enter the ODBC connection string that points to your database. Mine looks like "ODBC;DSN=BMNA;;", where BMNA is a DSN that I created to point to the AS/400 db. Screenshot of parms attached. I'd skip the V3R2 machine. The SQL engine on it is nowhere near as good as with newer OS/400 versions. HTH, Brian Singleton www.bsing.com
snap057.png
snap057.png
Comment