RE: ODBC timeout setting

["Elvis Budimlic" <ebudimlic@xxxxxxxxxxxxxxxxxxxxxxxxx>]

Also QUERY_TIME_LIMIT setting in QUSRSYS/QAQQINI file.
Our exit point tool provides an option to set this as well.
Programmatic interfaces have 'connection string' attributes that allow for
setting this as well.

All that said, most common case is that Allow Query Timeout is not unchecked
in the ODBC data source (DSN) under Performance-->Advanced (I wasn't clear
if that's the case from the original post).

HTH, Elvis

Celebrating 11-Years of SQL Performance Excellence on IBM i, i5/OS and
OS/400
www.centerfieldtechnology.com


-----Original Message-----
Subject: Re: ODBC timeout setting

WRKSYSVAL QQRYTIMLMT?  But I think that's estimated only.  If it kicks in, 
then this shouldn't stop it.

Rob Berendt