Re: Query AS/400 from SQL Server

It does. We install a full copy of client access on the server machine
to ensure all testing can be done on the server if necessary.

coy

-----Original Message-----
From: midrange-l-bounces@xxxxxxxxxxxx
[mailto:midrange-l-bounces@xxxxxxxxxxxx] On Behalf Of Mike Cunningham
Sent: Wednesday, 09 February, 2011 9:42 AM
To: Midrange Systems Technical Discussion
Subject: RE: Query AS/400 from SQL Server

Does this require the installation of the IBM ODBC or OLE DB or .NET
driver on the MS SQL server?

-----Original Message-----
From: midrange-l-bounces@xxxxxxxxxxxx
[mailto:midrange-l-bounces@xxxxxxxxxxxx] On Behalf Of Charles Wilt
Sent: Wednesday, February 09, 2011 12:30 PM
To: Midrange Systems Technical Discussion
Subject: Re: Query AS/400 from SQL Server

Create a "linked server" in MS SQL Server

Then you two options:
-- Pull all rows from the table(s) back and does the where locally
select * from FALCONPROD.S10316ZM.HLTHPRDFIL.LOCATP where locnbr =
'00335';

-- Sends the statement to linked server for processing select * from
openquery(FALCONPROD, 'select * from customp where locnbr = ''00335''');


As you can surmise, option 2 would be more efficient.


HTH,
Charles


On Wed, Feb 9, 2011 at 12:09 PM, Billy Waters
<bwaters@xxxxxxxxxxxxxxxxxx> wrote:

Can someone please provide the most efficient means of querying a view

on the AS/400 from SQL server? We need "real time" information from a
view across multiple BPCS files.

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


************************************************************************
The information in this e-mail is confidential and may be legally
privileged. It is intended solely for the addressee. Access to
this e-mail by anyone else is unauthorized. If you are not the
intended recipient, any disclosure, copying, distribution or any
action taken or omitted to be taken in reliance on it, is prohibited
and may be unlawful.
***********************************************************************

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