Information Center

General

SQL query timeout
Select the number of seconds that Host On-Demand waits for the remote database server to respond to the SQL query. Valid values are 1 through 3600 seconds, or 0 for no timeout.

If you specify a value other than 0 and you encounter timeouts due to slow communications networks or slow hosts, then you may want to increase the value of this option or set it to 0.

This value affects only SQL statements.

Start Trace Facility (Database On-Demand clients only)
Click this option to start the Host On-Demand trace facility, which records internal information about the Database On-Demand client that can be used for problem determination. Do not click this option unless your system administrator tells you to.

To specify a different value:
The SQL Wizard does not contain a field for specifying the SQL Query timeout. Therefore you cannot specify a different value in a particular SQL statement.

Related topics: