Re: AS400 and ODBC

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