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. 
     
     eric.delong@pmsi-services.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: 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 
+---
     


+---
| 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 thread ...


Follow On AppleNews
Return to Archive home page | Return to MIDRANGE.COM home page

This mailing list archive is Copyright 1997-2022 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.