Re: MS SQL 2012 OLEDB2 connection to the IBM i.

The format matters...

From my notes:
Linked Server name in MS SQL Server: FALCONPROD
IBM iSeries system name: MYIBM
Library: HLTHPRDFILE
Table: LOCATP

-- Pull all rows from the table(s) back and does the where locally
select * from FALCONPROD.MYIBM.HLTHPRDFIL.LOCATP where locnbr = '00335';

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

HTH,
Charles


On Mon, Sep 8, 2014 at 2:14 PM, Darryl Freinkel <
dfreinkel@xxxxxxxxxxxxxxxxx> wrote:

I have connected a SQL 2012 to the AS/400 and the connection is there.
However, I noticed that when I run scripts against the AS/400, they are
slow. Looking at what it is doing, I see either



1. SQL 2012 is reading all records in the database into memory and
then doing the selection in SQL 2012. We have 60 million records. All I
want
is 2 records.

2. The AS/400 is ignoring the where and is reading all records
sequentially to find the requested records.



This is the first time I am doing this. What am I missing?



I am on V5R4.



TIA



Darryl Freinkel

Assignment 400 Group, Inc.





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