InfoCenter

Setting Database On-Demand options for users

Click Database On-Demand Options to customize the behavior of Database On-Demand for individual users. Some of the options define how SQL statements are created, and some of the options define default values.

User options are grouped into the following categories:


An administrator can restrict end-users from modifying options. In this case, end-users do not see the window that includes the restricted option set.

General

Some host systems use schemas to separate databases or files into groups. For example, you may have separate employee database files (referred to as tables) for each department. These files might be named dept1.employee, dept2.employee, dept3.employee. If you select Use Schema, these tables are displayed with the schema names dept1, dept2, dept3 as part of the table name. If you do not select Use Schema, then only the employee portion of the table name is displayed, preventing the ability to distinguish between multiple tables with the same name.

The value for the SQL query timeout ranges from 0 to 3600 seconds (1 hour). If you experience timeouts due to slow communications networks or slow hosts, you may want to increase the value of this parameter. Specify 0 for no timeout.

Tables

Click this tab to customize the type of table from which you will select when constructing your SQL statement. Select the box next to the table type(s) that you want to display.

JDBC drivers support the ability to limit the table types returned from the database. You can specify which table types should be included.

You can choose to show all table types, or you can specify one or more of the following table types:

Drivers

Click the Drivers tab to register JDBC drivers other than the one provided as part of this program package. You can also remove a driver which has previously been registered.

To register a new driver:

  1. Type a description in the Driver description field. This field allows you to associate a descriptive phrase with a specific driver. For example, iSeries JDBC Driver or My favorite Java Database Driver.


  2. Type the class name for the driver you want to associate with the descriptive phrase in the Class name field. Make sure that your class name exactly matches the class name of the driver, including upper and lower case characters.


  3. Click Register Driver. The registered driver and description appears in the Registered Drivers section of the window. This indicates it has been registered or will be registered when you click OK.

To remove a previously registered driver:

  1. Select the description of the driver you want to remove from the Registered Drivers section.


  2. Click Remove.

Logon

Click the Logon tab to set default logon values for the database URL, user ID, and driver to be used when creating new SQL statements. You can also set a default value for the password.

Bidirectional options

Click the BIDI Options tab to set the bidirectional values used at the File Upload statement or the SQL Wizard statement. The BIDI Options tab is visible if your system is configured for Arabic or Hebrew.

Related topics