Re: AS/400 DSN on SQL Server

[image: Inline image 1]

Hi,

I'm getting this error!

SIPA SAYAKHOM
Don Quijote (USA) Co., Ltd.
801 Kaheka St., Honolulu, HI 96814
Phone: 808-973-6040
E-mail: sipa@xxxxxxxxxxxx

On Fri, Feb 10, 2017 at 11:17 AM, Rob Berendt <rob@xxxxxxxxx> wrote:

Charles,
What you are saying is important and I want to get out of here on Friday
afternoon also but add your opinion to both.

This sucks performance wise (Charles told you why in the dash dash)
<snip>
-- Pull all rows from the table(s) back to MS SQL server and do the where
locally
select * from LINKEDSVR.MYIBMI.MYLIB.MYTBL where locnbr = '00335';
</snip>

This is MUCH, MUCH, MUCH better on performance.
<snip>
-- Sends the statement to linked server for processing
select * from openquery(LINKEDSVR, 'select * from MYTBL where locnbr =
''00335''');
</snip>

Rob Berendt
--
IBM Certified System Administrator - IBM i 6.1
Group Dekko
Dept 1600
Mail to: 2505 Dekko Drive
Garrett, IN 46738
Ship to: Dock 108
6928N 400E
Kendallville, IN 46755
http://www.dekko.com





From: Charles Wilt <charles.wilt@xxxxxxxxx>
To: Midrange Systems Technical Discussion <midrange-l@xxxxxxxxxxxx>
Date: 02/10/2017 04:14 PM
Subject: Re: AS/400 DSN on SQL Server
Sent by: "MIDRANGE-L" <midrange-l-bounces@xxxxxxxxxxxx>



I assume you're trying to set up a linked server?

https://www-01.ibm.com/support/docview.wss?uid=nas8N1014514

Once you get connected, note the following:

-- Pull all rows from the table(s) back to MS SQL server and do the where
locally
select * from LINKEDSVR.MYIBMI.MYLIB.MYTBL where locnbr = '00335';

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

--OPENQUERY() isn't just for SELECTS
delete from openquery(LINKEDSVR, 'select * from MYTBL where locnbr =
''00335''');

Charles

On Fri, Feb 10, 2017 at 1:48 PM, Sipa Sayakhom <sipa@xxxxxxxxxxxx> wrote:

Hi,

Can you please point me in the right direction? We need to connect our

SQL

server to the A/S400? I've installed IBM Access for Windows 7.1, and

I'm

not able to connect from SQL Studio 2014 to the A/S400.

Thank you,

SIPA SAYAKHOM
Don Quijote (USA) Co., Ltd.
801 Kaheka St., Honolulu, HI 96814
Phone: 808-973-6040
E-mail: sipa@xxxxxxxxxxxx
--
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.

Please contact support@xxxxxxxxxxxx for any subscription related
questions.

Help support midrange.com by shopping at amazon.com with our affiliate
link: http://amzn.to/2dEadiD

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

Please contact support@xxxxxxxxxxxx for any subscription related
questions.

Help support midrange.com by shopping at amazon.com with our affiliate
link: http://amzn.to/2dEadiD


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

Please contact support@xxxxxxxxxxxx for any subscription related
questions.

Help support midrange.com by shopping at amazon.com with our affiliate
link: http://amzn.to/2dEadiD