Configuration levels for default parameter values in Database On-Demand

db_cfgr_cfglev.dita

A default parameter value is a default value that Database On-Demand automatically assigns to a parameter required for database access. For example, if the parameter required for database access is the URL of the database, then the default value could be jdbc:as400:myiSeries.

The parameters for which a default parameter value is available are:

  • Parameters in the General group (such as SQL query timeout)
  • Parameters in the Tables group (such as Table Filter)
  • Parameters in the Drivers group (such as Class name)
  • Parameters in the Logon group (such as Database Name)
  • Parameters in the BiDi group (such as Local-File Type)

A parameter for which a default parameter value is available can have up to four levels of configuration. Some of these parameters do not have all four levels. The levels are:

1. Disable Functions
At this level, the Database On-Demand administrator can disable the user's ability to set the parameter.
2. Default Parameter Values (Administrator)
At this level, the Database On-Demand administrator can specify an administrator's default value for the parameter.
3. Default Parameter Values (User)
At this level, the user can specify a user's default value for the parameter, unless the Database On-Demand administrator has disabled (at Level 1 above) the user's ability to do so. If the user does in fact specify a default value, then it overrides the Database On-Demand administrator's default value from Level 2.
4. New SQL statement or File Upload statement
At this level, when the user creates a new SQL statement or a new File Upload statement, Database On-Demand automatically sets the value of the parameter required for database access to the default value. Depending on the type of parameter, either:
  • The user must now accept the default value for the parameter in the new SQL statement or File Upload statement. (An example of such a parameter is the SQL query timeout, which is not configurable from within the SQL Wizard.) Or,
  • The user can specify a different value, unless the administrator has disabled (at Level 1 above) the user's ability to do so. (An example of such a parameter is the Table Filter.)

Access to windows Parameters in the General group Parameters in the Tables group Parameters in the Drivers group Parameters in the Logon group Parameters in the BiDi group

Access to windows

The following table shows how to open the windows referred to in the remaining sections of this help file.

Window: Access:
  • Database On-Demand Group Options window; or
  • Database On-Demand User Options window
From the Administration Utility:
  1. In the left pane of the Administration Utility, click Users/Groups.
  2. In the right pane, right-click the Group or User for which you want to set defaults or disable functions.
  3. Click Database > Options.
User Options window on the Database On-Demand client desktop From the Database On-Demand client desktop, click Options.

Parameters in the General group

The following table shows the four configuration levels for parameters in the General group. The only parameter in the General group is the SQL timeout value. The other checkboxes in the General group are used to disable functions. (To open the windows referred to in this table, follow the steps described in Access to windows.)

Configuration level: Location in the user interface:
1. Disable Functions The User Options pane of:
  • The Database On-Demand Group Options window; or
  • The Database On-Demand User Options window
2. Default Parameter Values (Administrator) The General pane of:
  • The Database On-Demand Group Options window; or
  • The Database On-Demand User Options window
3. Default Parameter Values (User) The General pane of:
  • The User Options window on the Database On-Demand client desktop
4. SQL statement or File Upload statement Not configurable

Parameters in the Tables group

The following table shows the four configuration levels for parameters in the Tables group. (To open the windows referred to in this table, follow the steps described in Access to windows.)

Configuration level: Location in the user interface:
1. Disable Functions The User Options pane of:
  • The Database On-Demand Group Options window; or
  • The Database On-Demand User Options window
2. Default Parameter Values (Administrator) The Tables pane of:
  • The Database On-Demand Group Options window; or
  • The Database On-Demand User Options window
3. Default Parameter Values (User) The Tables pane of:
  • The User Options window on the Database On-Demand client desktop
4. SQL statement or File Upload statement
  • The Tables tab of the SQL Wizard
  • The Table tab of the File Upload Wizard

Parameters in the Drivers group

The following table shows the four configuration levels for parameters in the Drivers group. (To open the windows referred to in this table, follow the steps described in Access to windows.)

Configuration level: Location in the user interface:
1. Disable Functions The User Options pane of:
  • The Database On-Demand Group Options window; or
  • The Database On-Demand User Options window
2. Default Parameter Values (Administrator) The Drivers pane of:
  • The Database On-Demand Group Options window; or
  • The Database On-Demand User Options window
3. Default Parameter Values (User) The Drivers pane of:
  • The User Options window on the Database On-Demand client desktop
4. SQL statement or File Upload statement
  • The Logon tab of the SQL Wizard
  • The Logon tab of the File Upload Wizard.

Parameters in the Logon group

The following table shows the four configuration levels for parameters in the Logon group. (To open the windows referred to in this table, follow the steps described in Access to windows.)

Configuration level: Location in the user interface:
1. Disable Functions The User Options pane of:
  • The Database On-Demand Group Options window; or
  • The Database On-Demand User Options window
2. Default Parameter Values (Administrator) Not configurable
3. Default Parameter Values (User) The Drivers pane of:
  • The User Options window on the Database On-Demand client desktop
4. SQL statement or File Upload statement
  • The Logon tab of the SQL Wizard.
  • The Logon tab of the File Upload Wizard.

Parameters in the BiDi group

The following table shows the four configuration levels for parameters in the BiDi group. (To open the windows referred to in this table, follow the steps described in Access to windows.)

Configuration level: Location in the user interface:
1. Disable Functions The User Options pane of:
  • The Database On-Demand Group Options window; or
  • The Database On-Demand User Options window
2. Default Parameter Values (Administrator) The BiDi Options pane of:
  • The Database On-Demand Group Options window; or
  • The Database On-Demand User Options window
3. Default Parameter Values (User) The Bidi Options pane of:
  • The User Options window on the Database On-Demand client desktop
4. SQL statement or File Upload statement Not configurable

Related topics: