Ok, here's something odd. I'm trying to write a query that accesses a DB2 database on an AS400. I'm connecting via ODBC just fine, but the admins for the AS400 have set a time limit of 1200 on all queries (to keep users from overloading the system).
I've built a query that runs off a HUGE table on the AS400 in order to build a subset of the data. The query runs just fine when first built, but once I save the query and reopen it, I get an error indicating I've gone over the 1200 time limit.
I've tried saving with different file names, prior to determining the exact error message. I've tried creating an OPAL script using the SQL statement from the working and unsaved query. I've also tried using a standard QBE statement in the script. In every case I get the time limit exceeded error.
This just seems rather odd that I can run the query just fine as long as I haven't saved it yet. Any ideas?
As a workaround, I'm going to create an outfile on the AS400 containing my subset of the data. That's a messy solution though.
-dw
I've built a query that runs off a HUGE table on the AS400 in order to build a subset of the data. The query runs just fine when first built, but once I save the query and reopen it, I get an error indicating I've gone over the 1200 time limit.
I've tried saving with different file names, prior to determining the exact error message. I've tried creating an OPAL script using the SQL statement from the working and unsaved query. I've also tried using a standard QBE statement in the script. In every case I get the time limit exceeded error.
This just seems rather odd that I can run the query just fine as long as I haven't saved it yet. Any ideas?
As a workaround, I'm going to create an outfile on the AS400 containing my subset of the data. That's a messy solution though.
-dw