RE: Link AS400 database wirh Access Database

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

My understanding is the data conversion happens within the ODBC
connection.  It is also possible your iSeries file may be too big for
Access to handle.

Yes, you can always try FTPing the iSeries file to your PC and importing
it into Access.  This would put the data conversion into the FTP.  No
need for Access to worry about library or member if you've FTP'd the
file to your PC.  You will be looking at importing a flat file.

-----Original Message-----
From: midrange-l-bounces+gary.monnier=powertech.com@xxxxxxxxxxxx
[mailto:midrange-l-bounces+gary.monnier=powertech.com@xxxxxxxxxxxx] On
Behalf Of Chaudhary, Sachin (GE Equipment Services,Consultant)
Sent: Thursday, January 20, 2005 4:28 PM
To: Midrange Systems Technical Discussion
Subject: RE: Link AS400 database wirh Access Database
Importance: High


1. Can't we choose to do this conversion on MS Access? Something like we
FTP the data to PC and then choose to open the file in Access?
2. Even if we can do this I wonder how can we select a library and a
file member??

Rgds,
Sachin

-----Original Message-----
From: midrange-l-bounces@xxxxxxxxxxxx
[mailto:midrange-l-bounces@xxxxxxxxxxxx]On Behalf Of Gary Monnier
Sent: Thursday, January 20, 2005 6:15 PM
To: Midrange Systems Technical Discussion
Subject: RE: Link AS400 database wirh Access Database


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.


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


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