Override Keywords: Load Process

This topic lists the override parameters available for a Load Process.

XFFILE

Override for the Extract File referenced by the Load Process.

xffile.xf: The name of the Extract File. Provide the full path if the file is not in the default directory.

CFFILE

Override for the Control File referenced by the Load Process.

cffile.cf: Name of the Control File. Provide the full path if the file is not in the default directory.

TMNAME

Override for the Table Map referenced by the Load Process.

identifier.tablemap name: Two-part name of an existing Table Map.

COLMAPID

Override for the default identifier for the Column Maps included in the Table Map.

identifier: The 1 - 8 character identifier.

COLMAP

Override for the Column Map name for a specific table in the Table Map. (A named Column Map can override a local Column Map.)

[ [ dbalias . ] cid . ] tablename: One, two, or three-part tablename. If tablename is not fully qualified, the default qualifier is used.

[ identifier . ] colmap: One or two-part name of an existing Column Map.

DESTQUAL

Override for the default qualifier for the destination tables in a Table Map.

Note: If you change the DB Alias portion of the destination qualifier, you must make the same change to all other DB Alias-specific Load-type overrides, including: MODE, PERFLOAD, DELONSUCCESS, DELONFAILURE, WORKPATH, and SERVPATH.

dbalias.creatorid: The two-part qualifier (DB Alias and Creator ID) for the destination tables.

DESTTABNAME

Override for the Source 1 and Source 2 tables in a Table Map.

srctabname: The source table name.

[ [ dbalias . ] cid . ] desttablename: One, two, or three-part destination table name. If the table name is not fully qualified, the default qualifier is used.

MODE

Override for the Loader processing mode for the database referenced by the dbalias.

dbalias: Specification used to access a particular database.

mode

Option for the Oracle Loader to insert, replace, append, or truncate data during the Load Process.

Append: Load rows from the Source File into the destination table. Append is only available when the DBMS is Oracle.

Insert: Insert rows from the Source File into empty destination tables.

Replace: Delete all rows from the destination tables and load rows from the Source File.

Truncate: Delete all rows from the destination tables and load rows from the Source File. Truncate is only available when the DBMS is Oracle.

PERFLOAD

Override for performing the load for the database.

dbalias: Specification used to access a particular database.

Y: Run the loader immediately after file conversion processing is complete.

N: The Load Process prepares the data in the appropriate format and creates the BAT file to run the loader, but does not initiate the loader.

DELONSUCCESS

Override to delete files for the database if the Load Process completes successfully.

dbalias: Specification used to access a particular database.

Y: Delete the data files after the loader completes successfully.

N: Do not delete the data files after the loader completes successfully.

DELONFAILURE

Override to delete files for the database referenced by the dbalias, if the Load Process fails.

dbalias: Specification used to access a particular database.

Y: Delete the data files if the loader does not complete successfully.

N: Do not delete the data files, if the loader does not complete successfully.

RSM

Override to estimate resources necessary to process this Load Request.

Y: Estimate the resources needed to process this Load Request. If you specify RSM Y, Optim™ creates a Resource Estimation Report for each object in the Load Request. The Load Request is not processed. For additional information see Resource Estimation.

N: Do not estimate resources for this Load Request. This is the default.

WORKPATH

Override for the workstation path to store temporary Oracle loader files.

dbalias: Specification used to access a particular database.

path: Directory path for storing temporary Oracle Loader files.

SERVPATH

Override for the server path to store temporary UDB loader files.

dbalias: Specification used to access a particular database.

path: Directory path for storing temporary UDB Loader files.

DESTDELIMITER

Override for specification to exclude or include delimiters in character data columns from being scanned by Optim while generating the loader file.

X'01', X'02', X'03', X'04', X'05': Use any of these values to exclude delimiters from scanning.

X'FA' X'FB' X'FC' X'FD' X'FE' X'FF': Use any of these values to include delimiters in scanning.

SOURCEEMPTY

Override for the option to perform the load if a table to be loaded contains no rows. Specify:

dbalias: Specification used to access a particular database.

Y: Complete the load if a table to be loaded contains no rows, deleting any rows from the target.

N: Skip empty tables.

COMMITFREQ: Override for commit frequency. Specify the number of rows after which the loader commits changes to the database, up to the limit specified in Product Options. Refer to the Installation and Configuration Guide section on Product Options.