Dialogs

The Configuration program presents a series of dialogs to complete a specific task. You respond to prompts or provide necessary information and proceed to the next step in the process.

Some configuration dialogs are used in a number of different tasks; however, only the options appropriate for a specific task are available. In this guide, unavailable options are explained only if certain conditions cause them to become active.

Most configuration dialogs include the following items:

Command buttons

Here is a list of the most common command buttons.

Previous
Return to the previous dialog. This button is not present in every dialog.
Proceed
Perform any tasks that are initiated by the current dialog with the information that is provided, close the dialog, and open the next dialog in sequence.
Skip
Skip one or more logically related dialogs or tasks. This button is not present in every dialog and is sometimes unavailable.
Undo
Restore the dialog to its initial status. This button is not present in every dialog.
Cancel
Close the current dialog and return control to the Configuration main window. This button is present in every dialog.

DBMS terms

The Optim solution supports several database management systems. Terms that are used in a configuration dialog reflect the DBMS for the database that is being configured. For example, when you configure an Oracle database, a configuration dialog refers to "Packages" to access database tables. However, when you configure a Sybase ASE or SQL Server database, the same dialog refers to "Procedures," and for a DB2® database it refers to "Plans." Varying terms are noted in the description of a dialog. In some instances, a particular DBMS might require a unique dialog. In that case, both the common dialog and the unique dialog are illustrated and described.

Display SQL

If the Configuration program creates data definition language statements or DDL, the pertinent dialog includes a check box, Display SQL. To review DDL statements before they are executed, select this check box. To execute a task without review, clear the check box.

Note: The Configuration program creates a text file, sql.txt, containing the DDL generated during the current and previous sessions. You can browse or print this file with a text editor, such as Notepad. The file is generated whether or not you select Display SQL on a particular dialog and is stored in the default Temp directory.

If you select Display SQL and click Proceed, the Browse SQL dialog opens.

Example of the Browse SQL dialog

The Browse SQL dialog displays the generated DDL statements in sequence:

Note: The check box to Display SQL is dynamic. If selected or cleared on one dialog, it automatically changes on other dialogs, where appropriate.


Feedback