I have created a linked server in SQL Server 2000 to a DB2 database on AS/400. I use de OPENQUERY statement to create a view in SQL Server that selects * from a table in DB2. The table in DB2 consists of 4301 records, but the view in SQL Server only shows 356 records of this table. I can order the records, so I know that my view 'sees' all 4301 records of the DB2 table.
How can I get all the records from the DB2-table in my SQL Server view?