IBM AS/400 - Estimated Query Time too long. HELP?

[Silentz]

I am running a very simple query in ASP against an AS/400 database server. The table I am querying has
over 28000 records/rows, and when I execute the query it returns the following error:


Microsoft OLE DB Provider for ODBC Drivers error '80004005'

[IBM][Client Access ODBC Driver (32-bit)][DB2/400 SQL]SQL0666 - Estimated query processing time 36 exceeds
limit 30.



As I said, the SQL query is very simple:

SELECT * FROM table WHERE field = 0;

If i import the as400 table into MS Access and run the query it works fine.

Obviously there a limit to the amount of time a query can use on an AS/400 server.

WHAT I WANT TO KNOW IS:

Can this setting be changed?
if so:
Where do I find this setting?
What problems might I face if i extend the time?

Please help as much as you can - even if the answer is "it cant be changed".

Thanks in advance.