Load Tab

Use the Load tab to customize loader parameters and enforce loader requirements for your site. This can be particularly helpful when you have more than one database, or more than one Optim™ Directory. You can specify default parameters applicable to all defined DB Aliases, and as needed, specify unique parameters for each different database, each instance or version of a database, or each different Optim Directory.

For example, after selecting an Optim Directory, you can select [Default] in the DB Alias box. Loader settings you define will apply to all DB Aliases in the selected Optim Directory. If the default settings are not appropriate for one DB Alias, you can select that DB Alias in the DB Alias box, select the Override default settings check box, and define specific settings for that DB Alias only. You can repeat the procedure for any or all DB Aliases in the selected Optim Directory, and similarly, for all DB Aliases in each Optim Directory.

Product Options dialog - Load tab

Optim Directory

Select the name of the Optim Directory containing the DB Aliases for which you want to customize loader parameters. If your site has more than one Optim Directory, and you want to specify loader parameters for DB Aliases contained in those directories, click the down arrow to select from a list.

DB Alias

Click the down arrow to select from the available DB Aliases in the selected Optim Directory. If you select [Default], the custom loader parameters you specify apply to all DB Aliases in the selected Optim Directory.

Override default settings

Select to define unique loader parameters for a specific DB Alias, when default values are defined for all DB Aliases in a selected Optim Directory.

Use Delete, when Truncate fails

This check box is applicable to SQL Server and Sybase ASE DB Aliases only. When Replace is specified in a Load Request, data loaded to the affected tables is truncated, unless the particular table is partitioned, in which case the truncate action will fail. Select this check box to issue the SQL Delete statement when the SQL Truncate statement fails.

Note: The SQL Delete statement may be significantly more resource‑intensive than the SQL Truncate statement.

Loader Parameters

Additional Loader Parameters
Define additional loader parameters, as required, to append to the list created by Optim for loading data with a DBMS loader. See DBMS documentation for valid operands.
Force at Run Time
Select to force the use of the additional loader parameters defined in Product Options in place of any additional loader parameters specified in a particular Load Request.
Use to prime New Request
Select to populate new Load Requests with the additional loader parameters defined in Product Options. These parameters may be edited in the individual Load Requests, as necessary.


Feedback