RE: AS400 and ODBC

Some of these comments are using the assumption that you only need a
relatively small portion of these large files reported.

If you don't need "real time" data that the PC queries give you. Say your
data is not in flux on a minute by minute basis. You can write AS400 Queries
to do the filtering for you, and put these on a scheduler. Then do your ODBC
links to these. This is the solution for our business. Some of the records
are updated hourly, some as little as twice daily. The largest record on the
AS400 we query against using Access is @ 6,000 rows X 24 columns. We get
summary results from this in about 10 seconds.

There is also a way in VB to do "pass thru" statements that call on AS400
native SQL or whatever, again, putting the filtering process back to the 400
where it will run much, much faster. We have not yet run these, but have
read articles about this capability. 

Learn VB



Dale Draper
Sega Enterprises, Inc. (USA)
Dale.Draper@seu.sega.com



> -----Original Message-----
> From: Edward Koziol [SMTP:koziol@chaney.net]
> Sent: Thursday, October 07, 1999 12:20 PM
> To:   MIDRANGE-L@midrange.com
> Subject:      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
> +---
+---
| 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
+---