Re: Query AS/400 from SQL Server

I suggest using a Linked Server within SQL Server

[1]Inactive hide details for Billy Waters ---02/09/2011 09:10:50 AM---Can
someone please provide the most efficient means of queryBilly Waters
---02/09/2011 09:10:50 AM---Can someone please provide the most efficient
means of querying a view on the AS/400 from SQL server

From: Billy Waters <bwaters@xxxxxxxxxxxxxxxxxx>
To: "midrange-l@xxxxxxxxxxxx" <midrange-l@xxxxxxxxxxxx>
Date: 02/09/2011 09:10 AM
Subject: Query AS/400 from SQL Server
Sent by: midrange-l-bounces@xxxxxxxxxxxx

--------------------------------------------------------------------------

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: [2]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 [3]http://archive.midrange.com/midrange-l.

This email and any files transmitted with it are confidential and intended
solely for the use of the individual or entity to whom they are addressed.
Unless you are the addressee (or authorized to receive for the addressee),
you may not use, copy or disclose to anyone this email or any information
contained in this email. If you have received this email in error, please
advise the sender by replying to this email, and delete this email
immediately. Please note that any views or opinions presented in this
email are solely those of the author and do not necessarily represent
those of Western Dental Services, Inc. Finally, the recipient should check
this email and any attachments for the presence of viruses. Western Dental
Services, Inc. accepts no liability for any damage caused by any virus
transmitted by this email.

References

Visible links
2. http://lists.midrange.com/mailman/listinfo/midrange-l
3. http://archive.midrange.com/midrange-l