RE: ODBC Error when importing a LF to Access

You have the query governor set up to limit queries to only 60 seconds of
processing time.  It's probably a System level value (WRKSYSVAL
SYSVAL(QQRYTIMLMT)).  

Thank you,
Matt Tyler
WinCo Foods, LLC
mattt@xxxxxxxxxxxxxx

-----Original Message-----
From: rpg400-l-bounces@xxxxxxxxxxxx [mailto:rpg400-l-bounces@xxxxxxxxxxxx]
On Behalf Of Douglas W. Palme
Sent: Thursday, July 28, 2005 8:39 AM
To: RPG Group
Subject: ODBC Error when importing a LF to Access

We have a LF built on our 400 which we were trying to import to access to 
verify some data....however when we try to import we are getting the 
following error message:

ODBC--call failed.

[IBM]iSeries Access ODBC Driver][DB2 UDB]SQL666 - Estimated query processing

time 415 exceeds limit 60.

Any idea what the heck is going on?


If you bought, it was hauled by a truck - somewhere, sometime.