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
.)
- 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
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: |
---|---|
|
From the Administration Utility:
|
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:
|
2. Default Parameter Values (Administrator) | The General pane of:
|
3. Default Parameter Values (User) | The General pane of:
|
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:
|
2. Default Parameter Values (Administrator) | The Tables pane of:
|
3. Default Parameter Values (User) | The Tables pane of:
|
4. SQL statement or File Upload statement |
|
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:
|
2. Default Parameter Values (Administrator) | The Drivers pane of:
|
3. Default Parameter Values (User) | The Drivers pane of:
|
4. SQL statement or File Upload statement |
|
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:
|
2. Default Parameter Values (Administrator) | Not configurable |
3. Default Parameter Values (User) | The Drivers pane of:
|
4. SQL statement or File Upload statement |
|
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:
|
2. Default Parameter Values (Administrator) | The BiDi Options pane of:
|
3. Default Parameter Values (User) | The Bidi Options pane of:
|
4. SQL statement or File Upload statement | Not configurable |