We help IT Professionals succeed at work.
Get Started

Incomplete result sets connecting through MSSQL linked server to AS400 DB2 using ODBC driver

1,106 Views
Last Modified: 2008-09-22
I have a linked server going from MSSQL 2000 sp3a to DB2 on an AS400 server using the client access 32bit odbc driver and am getting back odd results from the database.

Depending on what column I choose, I get back different record counts.  It has been very consistent in behavior but no pattern has emerged, other than the byte count seems to be divisible by 1024 bytes.  We have tried the IBM DB2 UDB for iseries OLE DB driver and had similar results but different row counts.

koeng--2 bytes
nrklx--6 bytes
koenl--3 bytes
bever--15 bytes
This table has 26446 records total.  None of the queries bring back anything close to that.

select * from openquery(as400_dsn,'select koeng from AS4GF900.KLLEVPF')--16384
select * from openquery(as400_dsn,'select nrklx from AS4GF900.KLLEVPF')--8192
select * from openquery(as400_dsn,'select bever from AS4GF900.KLLEVPF')--4096
select * from openquery(as400_dsn,'select koenl from AS4GF900.KLLEVPF')--10922
select nrklx from openquery(as400_dsn,'select * from AS4GF900.KLLEVPF')--4096
select * from openquery(as400_dsn,'select * from AS4GF900.KLLEVPF')--284

How do I get the entire result set from this connection mechanism?

Comment
Watch Question
This problem has been solved!
Unlock 1 Answer and 4 Comments.
See Answer
Why Experts Exchange?

Experts Exchange always has the answer, or at the least points me in the correct direction! It is like having another employee that is extremely experienced.

Jim Murphy
Programmer at Smart IT Solutions

When asked, what has been your best career decision?

Deciding to stick with EE.

Mohamed Asif
Technical Department Head

Being involved with EE helped me to grow personally and professionally.

Carl Webster
CTP, Sr Infrastructure Consultant
Ask ANY Question

Connect with Certified Experts to gain insight and support on specific technology challenges including:

  • Troubleshooting
  • Research
  • Professional Opinions
Did You Know?

We've partnered with two important charities to provide clean water and computer science education to those who need it most. READ MORE