Re: Link AS400 database wirh Access Database

[pnelson@xxxxxxxxxx]

The ODBC connection runs at priority 20, which is the same as interactive. 
If you don't know what you're doing, you can kill performance. You'd be 
better off with writing a program to create a flat file with the data you 
want and then use Access to get at that data set.


Paul Nelson
Arbor Solutions, Inc.
708-670-6978  Cell
pnelson@xxxxxxxxxx





"Chaudhary, Sachin (GE Equipment Services,  Consultant)" 
<sachin.chaudhary@xxxxxx>
Sent by: midrange-l-bounces@xxxxxxxxxxxx
01/20/2005 06:09 PM
Please respond to Midrange Systems Technical Discussion
 
        To:     "Midrange Systems Technical Discussion" 
<midrange-l@xxxxxxxxxxxx>
        cc: 
        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.