Sounds a bit extreme to be pursuing something like this just yet.... I'd suggest that some access path tuning could probably help this situation. If the query optimizer doesn't have the proper access paths to work with, it could very well spell disaster for ODBC access of large databases. email@example.com ______________________________ Reply Separator _________________________________ Subject: Re: AS400 and ODBC Author: <MIDRANGE-L@midrange.com> at INET_WACO Date: 10/7/99 1:20 PM Sounds like it is time to consider a more robust software tool to automate this for you and replace ODBC inefficiencies. I have used DataMirror Corporations "TRANSFORMATION SERVER" quite effectively moving data from the AS/400 to an NT/SQL server with right now results. If you need additional information, please give me a call. Ed Koziol Chaney Systems, Inc. 414-679-6000 > From: "Vuong Nguyen" <vuongn1@Hotmail.com> > To: MIDRANGE-L@midrange.com > Subject: AS400 and ODBC > Date: Thu, 07 Oct 1999 09:16:56 PDT > Reply-to: MIDRANGE-L@midrange.com > Hello folks: > > It has been a while for me to asking the list for help and please forgive me > if I ask the wrong questions or offend anybody. > > Please allow me to refresh the list's memory about me. I am very, very new > with the AS/400. I did get a lot of tips from the list of where to start > with learning about the AS/400. I entered in the AS/400 world for almost a > year now, and have learn somewhat to get my job done. I am creating a > database using Microsoft product, automate and retrieve up-to-date data > directly from the AS/400 files through the use of ODBC linking. I am > somewhat successful in several small databases, BUT, I have the problem with > retrieving a big junk of record for the company database. > > The volume of data is growing every day, so of course, eventually what > volumne I get for this week will be different than last week. But the past > week and the weeks before that, the retrieving process would take no longer > than 5 minutes, but today it takes hours and have not retrieve the > information out of the AS/400 yet. I used ODBC link to the AS/400 files, > then use PC queries to filter the data that I need and put it in a temp > files. > > I am still somewhat a new comer to these territory. I am very grateful for > any advise, suggestions or tips to show me lights to my problems. > > Greatly appreciated, Vuong. > > ______________________________________________________ > Get Your Private, Free Email at http://www.hotmail.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: firstname.lastname@example.org > +--- > +--- | 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: email@example.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: firstname.lastname@example.org +---
As an Amazon Associate we earn from qualifying purchases.
Operating expenses for this site are earned using the Amazon Associate program and Google Adsense.