RE: Link AS400 database wirh Access Database

And to think, we had people upload data from their PC's to the iSeries so 
that they could run Query on them - they loved it.

Rob Berendt
-- 
Group Dekko Services, LLC
Dept 01.073
PO Box 2000
Dock 108
6928N 400E
Kendallville, IN 46755
http://www.dekko.com





MWalter@xxxxxxxxxxxxxxx 
Sent by: midrange-l-bounces+rob=dekko.com@xxxxxxxxxxxx
01/21/2005 12:40 PM
Please respond to
Midrange Systems Technical Discussion <midrange-l@xxxxxxxxxxxx>


To
Midrange Systems Technical Discussion <midrange-l@xxxxxxxxxxxx>
cc

Subject
RE: Link AS400 database wirh Access Database






Cause, they ain't pretty!  !  !

Thanks,

Mark

Mark D. Walter
Senior Programmer/Analyst
CCX, Inc.
mwalter@xxxxxxxxxx
http://www.ccxinc.com


 
             pnelson@xxxxxxxxx 
             m 
             Sent by:                                                   To 

             midrange-l-bounce         Midrange Systems Technical 
             s@xxxxxxxxxxxx            Discussion 
                                       <midrange-l@xxxxxxxxxxxx> 
                                                                        cc 

             01/21/2005 12:32 
             PM                                                    Subject 

                                       RE: Link AS400 database wirh Access 

                                       Database 
             Please respond to 
             Midrange Systems 
                 Technical 
                Discussion 
             <midrange-l@midra 
                 nge.com> 
 
 




Why would these programmers use Access to analyze data on the iSeries?
What's the matter with Query/400 or DBU or one of the many other tools?


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/21/2005 11:20 AM
Please respond to Midrange Systems Technical Discussion

        To:     "Midrange Systems Technical Discussion"
<midrange-l@xxxxxxxxxxxx>
        cc:
        Subject:        RE: Link AS400 database wirh Access Database


Yes you are right. There is already set of logical files and the
processing/reports etc go perfectly fine in production env. I just wanted
to do this for the new programmers who keep analysing data by opening
files and running SQLs time and again. We do not have a separate test
box:)

-----Original Message-----
From: midrange-l-bounces@xxxxxxxxxxxx
[mailto:midrange-l-bounces@xxxxxxxxxxxx]On Behalf Of Gary Monnier
Sent: Friday, January 21, 2005 10:50 AM
To: Midrange Systems Technical Discussion
Subject: RE: Link AS400 database wirh Access Database



There are many ways to solve your dilemma. One is, unless you really
have your heart set on doing this through Access, is to use a logical
file keyed in the sequence you want your query in and run your query
over the logical view.  Using this logical view will reduce the amount
of time and CPU your query uses.  And yes, it will take some CPU to
build the logical view, but you can schedule it to be created/installed
during slow hours.

If your file is really enormous you may be better off writing a program
to spin through it, filter out records you don't want to report on,
write those that you do want to report on to a separate physical file
and run your query over your new file.




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



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