Administration tools configuration

You can specify which features are shown or enabled by the administration tools using the initialization file named OEM.ini. This file must be in the same directory as the JAR files used by the administration tools (for example, C:\Program Files\SQL Anywhere 12\java). If the file is not found, default values are used. Also, defaults are used for values that are missing from OEM.ini.

Note

When you redeploy the administration tools, the tools cannot check for SQL Anywhere software updates. The Check For Updates menu items and options do not appear in redeployed versions.

Here is a sample OEM.ini file:

[errors]
# reportErrors type is boolean, default = true
reportErrors=true

[updates]
# checkForUpdates type is boolean, default = true
checkForUpdates=true

[preferences]
directory=preferences_files_directory

[dbisql]
allowPasswordsInFavorites=true
disableExecuteAll=false
# lockedPreferences is assigned a comma-separated 
# list of one or more of the following option names:
#    autoCommit
#    autoRefetch
#    commitOnExit
#    disableResultsEditing
#    executeToolbarButtonSemantics
#    fastLauncherEnabled
#    maximumDisplayedRows
#    showMultipleResultSets
#    showResultsForAllStatements
lockedPreferences=showMultipleResultSets,commitOnExit

Any line beginning with the # character is a comment line and is ignored. The specified option names and values are case-sensitive.

The OEM.ini file is divided into the following sections:

[errors]

[updates]

[preferences]

The option set in this section applies to all administration tools.

You can set the directory option to specify the directory used by the administration tools to save user-specific configuration files. These files contain information related to the administration tools' settings and history. For example, they may contain Interactive SQL statement history, recently opened files, or saved window positions.

You must specify a fully-qualified directory name (such as c:\work\prefs) that does not end with a path separator (backslash on Windows; forward slash on Linux, Unix, and OS X).

On Windows, the default setting for the user preferences directory is %userprofile%\sybase. This setting permits multiple users on a single system to each have their own directory for the recording of preferences. Overriding this setting in the OEM.ini file disables this capability.

[dbisql]

The options set in this section apply only to Interactive SQL.

allowPasswordsInFavorites If allowPasswordsInFavorites is false, Interactive SQL removes the Save The Connection Password checkbox from the Add To Favorites window. The default setting is true, which means the checkbox is present. See Saving SQL script files and connections in a favorites list.
disableExecuteAll If disableExecuteAll is true, then the SQL » Execute menu item and the F5 accelerator key are disabled in Interactive SQL. If the Execute toolbar button is configured for Execute, then it is disabled also. Therefore, you might want to set the Execute toolbar button to Execute Selection in Interactive SQL, and then set the executeToolbarButtonSemantics option in the OEM.ini file to prevent users from changing the Execute toolbar button. See Configuring the Execute Statements toolbar button.

lockedPreferences You can lock the settings of Interactive SQL options so that users cannot change them. The option names are case sensitive. The following is an example:

[dbisql] lockedPreferences=autoCommit

You can prevent users from changing the following Interactive SQL option settings:

autoCommit Prevents users from customizing the Commit After Every Statement option. See auto_commit option [Interactive SQL].
autoRefetch Prevents users from customizing the Automatically Refetch Results option. See auto_refetch option [Interactive SQL].
commitOnExit Prevents users from customizing the Commit On Exit Or Disconnect option. See commit_on_exit option [Interactive SQL].
disableResultsEditing Prevents users from customizing the Disable Editing option.
executeToolbarButtonSemantics Prevents users from customizing the behavior of the Execute toolbar button. See Configuring the Execute Statements toolbar button.
fastLauncherEnabled Prevents users from customizing the fast launcher option. See Fast launcher option.
maximumDisplayedRows Prevents users from customizing the Maximum Number Of Rows To Display option. See isql_maximum_displayed_rows option [Interactive SQL].
showMultipleResultSets Prevents users from customizing the Show Only The First Result Set or Show All Result Sets options. This setting also prevents the user from setting the isql_show_multiple_result_sets option. See isql_show_multiple_result_sets option [Interactive SQL].
showResultsForAllStatements Prevents users from customizing the Show Results From The Last Statement or Show Results From Each Statement options. See Returning multiple result sets from procedures.

Discuss this page in DocCommentXchange.