My first guess is that you are running MS Access or some other program that’s having all the records delivered to it, then processed. Write your query to run as a view or stored procedure. That way, the query will run on the 400, and just deliver the result over ODBC.
Linker Systems, Inc.
+1-949-552-1904 from outside of North America