Specify the language set used to enter and display SQL and data. This setting does not affect the language of the program interface. It is always in English.

Specify whether to show an animation describing the optimization process. This option is useful for first time users. It also indicates that the optimization process is still working when the process bar stays at the same percent for a long period of time.

Specify that the first window you open is maximized. Every window that you open after that also opens maximized.

If you "restore down" a window, then all open windows are "restored down" and any other window that is open is not maximized as it is opened. Once all windows are closed, the next window that is open is maximized as it is opened.

Note: This feature only applies to windows with the Minimize, Maximize, and Close boxes in the upper right corner of the window.

Specify that the database dictionary is automatically loaded into the memory of the computer every time you connect to a database.

When this option is not selected, the specific information needed from the database is loaded when the SQL statement is parsed for functions such as scanning, optimization, and index generation. This save time when you are initially connecting to the database from each module, but it adds a slight bit of time later when the SQL statement is parsed.

Define the number of rows used to fetch rows returned by the SQL statement while retrieving the run time for all records.

Specify to save the parameter information that you enter into the Parameters window so that next time that you are prompted to enter the values for the parameters, the data type and value that you last used for a parameter name are automatically entered for you. The parameter names are case sensitive, so dpt_id and DPT_ID are treated as two different parameters. The directory where this information is save is set in the Directory Setup options.

Specify the maximum number of parameters that will be saved. When the maximum number is reached, the parameter name that is the longest unused will be removed from the file when a new parameter name is added.