RE: Link AS400 database wirh Access Database

Hi guys - I don't want to accused of selling - well not toooo much
anyway! 

Would there be a situation here where you are wanting to extract a
subset of the database for testing purposes ? if so we do have a
solution for that - it is called EXTRACTOR and is a small module from
the TestBench suite.

Please email me off-list if you would like mire information.

Many thanks 

Jamie 
Jamie.coles@xxxxxxxxxxxx 

Jamie Coles
Original Software
(UK) +44 (0)1256 338666
(US) +1 630-321-0092
http://www.origsoft.com
Leading automated testing solutions
for the IBM iSeries, Microsoft & Oracle.
Original Software does not accept responsibility for changes
made to this message after it was sent. This email and any
files transmitted with it are confidential and intended solely
for the use of the individuals or entity to whom they are
addressed.


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

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.