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.