Re: SQL0666 on VB application doing SQL on AS400 file

[Charles Wilt <charles.wilt@xxxxxxxxx>]

Query timeout can be set in multiple places...
https://www.ibm.com/support/pages/odbc-query-timeout-property-sql0666-estimated-query-processing-time-exceeds-limit

I'd suspect the QAQQINI file since you already checked the system value...

But I'd be curious as to what the failing queries have in common.

Wondering if an access path is being rebuilt or something related to the
unplanned power down.

Good luck!
Charles


On Fri, Jan 23, 2026 at 2:38 PM Versfelt, Charles via MIDRANGE-L <
midrange-l@xxxxxxxxxxxxxxxxxx> wrote:

> We have a number of VB applications accessing the AS/400.  At some point
> yesterday, an accidental IPL of the AS/400 took place.
> A coworker was trying to add an external tape drive and suddenly the
> system went down. I don't know if he pressed a button, or what.
> The system just went down. I believe some PTFs were installed when the
> system came back up.
> Anyway, now some of our VB applications are failing when trying to do a
> SQL on an AS/400 file.
> I don't think this happening after a sudden unplanned IPL is a coincidence.
> The error my VB applications is getting is SQL0666.
>
> In my research I found this link,
> https://www.itjungle.com/2005/07/13/fhg071305-story03/
> System value QQRYTIMLMT is *NOMAX.  Following the instructions in the
> itjungle link, I went to ODBC Data Source Configuration.
> I checked every Data Source, there were four, only one allowed
> "Configure," the others it was greyed out.
> That one, I saw and unclicked "Enable Query Timeout" and clicked ok.
> I'm still getting the error.  I'm not sure how to fix this time out issue.
>
> Thanks,
> Charles Versfelt
> --
> This is the Midrange Systems Technical Discussion (MIDRANGE-L) mailing list
> To post a message email: MIDRANGE-L@xxxxxxxxxxxxxxxxxx
> To subscribe, unsubscribe, or change list options,
> visit: https://lists.midrange.com/mailman/listinfo/midrange-l
> or email: MIDRANGE-L-request@xxxxxxxxxxxxxxxxxx
> Before posting, please take a moment to review the archives
> at https://archive.midrange.com/midrange-l.
>
> Please contact support@xxxxxxxxxxxxxxxxxxxx for any subscription related
> questions.