General (Administrator)

For information about allowing users to change the value of these parameters, see Parameters in the General group.

Allow creating SQL/File Upload statements

Allows a user to create SQL statements and File Upload statements.

Allow saving SQL/File Upload statements

Allows a user to save SQL statements and File Upload statements.

Allow deleting SQL/File Upload statements

Allows a user to delete SQL statements and File Upload statements.

Allow manual editing of SQL statements

Allows a user to edit SQL statements.

Allow editing of Table filter

Allows a user to modify or replace the list of schema names, schema filters, table names, and table filters that is specified by the Database On-Demand administrator and that determines the contents of the List of available tables in both the SQL Wizard and the File Upload Wizard.

The Database On-Demand administrator specifies this list:

• In the Table Filter field of the Tables pane of the Database On-Demand Group Options window or the Database On-Demand User Options window.

See Table Filter (Administrator, Database On-Demand).

For more information see Levels of filtering for schema names and table names.

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.

See Parameters in the General group.

Related topics: