RE: Link AS400 database wirh Access Database

["Gary Monnier" <gary.monnier@xxxxxxxxxxxxx>]

Access will have to perform a data conversion before your new query can
run.  You may use more CPU converting EBCDIC to ASCII that your original
query used.

-----Original Message-----
From: midrange-l-bounces@xxxxxxxxxxxx
[mailto:midrange-l-bounces@xxxxxxxxxxxx] On Behalf Of Chaudhary, Sachin
(GE Equipment Services,Consultant)
Sent: Thursday, January 20, 2005 4:09 PM
To: Midrange Systems Technical Discussion
Subject: Link AS400 database wirh Access Database


Hi

I want to run query on one of the largest files on AS400. Since it eats
up a lot of CPU , I thought of Linking the file to Access database using
ODBC connection. 
I will run the query in Access, and leave it overnight so that AS400 CPU
usage is not affected at all.
However when I chose link table in MS Access , and try to select ODBC
Databases, it offers selection of files from only 2 libraries PSCOMMON
and QGPL!. There is no browse button so that I can select a particular
production library, neither can I select any particular member of the
file?
Isn't this weird??
Is there any place where I can get some info about AS400-MS Access??

Rgds,
Sachin

-- 
This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing
list
To post a message email: MIDRANGE-L@xxxxxxxxxxxx
To subscribe, unsubscribe, or change list options,
visit: http://lists.midrange.com/mailman/listinfo/midrange-l
or email: MIDRANGE-L-request@xxxxxxxxxxxx
Before posting, please take a moment to review the archives
at http://archive.midrange.com/midrange-l.