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: 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.