Previous Topic Next topic Print topic


Options Utility

Restriction: This topic applies to Windows environments only.

Use the Options utility for configuring the SQL Option client-side software and its connectivity with XDB and DB2 database servers.

The settings that you can change fall into the following categories:

The Options utility has a Summary page that enables you to obtain a list of all the current configuration settings. You cannot make changes to any of the options from the Summary tab but you can print it for reference purposes.

To access the Options utility from the main menu, Run > Tools > Data Tools > SQL Option for DB2 > Configuration > Client Options.

The Options window is made up of several pages, each labeled with a tab. To view or change information on a particular page, click its tab.

The options that you select are stored in the xdb.ini file.

To ensure backward compatibility, the settings are also written to the config.xdb file. These files are usually found in your configuration directory. For more information about xdb.ini, see xdb.ini File Structure.

Note: If SQLWizard is running when you change your preferences using Options, you must exit from SQLWizard and restart it before the changes take effect.

Along the left edge of the window is a set of general-purpose buttons. Depending upon which tab you are working in, some or all of these buttons will be available to you.

OK This button accepts the current configuration and writes the settings to the xdb.ini and CONFIG.XDB files, and any other configuration files used by your system. Exits Options.
Cancel This button discards the changes made during the current session and exits Options.
Browse This button becomes active when your cursor is in a field requiring a path, filename or location. Clicking Browse provides a dialog box for you to select a name.
Edit This button is displayed when the current tab offers editable fields such as formats for days or months.
Help This button displays a help window containing information about the current tab.
Previous Topic Next topic Print topic