General Tab

Use the General tab to identify the Temporary Work Directory, Data Directory, and the directory for the Product Configuration File used by the workstation, and other defaults.

Use ‘_' as SQL LIKE Character

Select to use the underscore character to represent any single character in a pattern. For example, if Use ‘_' as SQL LIKE Character is selected, you can type PSTDEMO.M _ _ P in the pattern box on the Open an Access Definition dialog to list only Access Definitions with a name beginning with M and ending with P for the Identifier PSTDEMO. If you clear this check box, the underscore represents the underscore character.

Caps Mode

Select to translate all string literal characters in selection criteria, relationships, and Column Maps to uppercase. If you clear this check box, characters display exactly as entered.

z/OS Code Page

In an Optim™ process, you can use an Extract File created using Optim z/OS®. Optim uses a code page to convert the mainframe file format. In the z/OS Code Page list, select a default value to be used if the Extract File does not contain a code page number.

Days to keep Trace files

Specify the number of days (2 to 30) to retain trace files in the temporary work directory. The default value is 5.

Trace files are useful for tracking processing. Each trace file name begins with PR0 and ends with a numeric extension (for example, PR0TOOL.123). The second part of the name identifies the type of trace file. Trace files are sequentially numbered .001 through .999, followed by .A00 through .Z99, as necessary. If more than 3,599 trace files of a type are created and stored within the specified number of days, file names are reused, beginning with the first.

Note: Consider storage space limitations when deciding the number of days to retain the files.

Temporary Work Directory

Specify the complete path to the default directory in which you want to store internal work files and trace files. To select from your system directories, click the browse button.

Data Directory

Specify the complete path to the default directory in which you want to store Archive, Extract, Control, Compare, and Export Files, and other process files. To select from your system directories, click the browse button. The Data Directory serves as the default; you can specify a different directory path and file name on any process request.

Product Configuration File

Specify the complete path to the Product Configuration File. The file name has a .cfg extension. To select from your system directories, click the browse button. The Product Configuration File is created when you install Optim.

Local Optim Server (ODBC Connections Only)

To improve ODBC response times, select the name of the Optim Server that runs on this machine. The ODBC Server will run locally and the Server will not be contacted, if an ODBC connection specifies this Server name, or if the ODBC interface selects an Archive File with this Server name in its Archive Directory entry.

Note: Do not use this setting if accessing archived data on a backup device.