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:
- TRIGMODE
- Override for disabling database triggers. Specify:
- Never
- Do not disable database triggers for the loader.
- Always
- Disable database triggers during the Load Process and then re-enable
the triggers after the process completes.
- Prompt
- Display the Disabling Trigger/Constraint Confirmation dialog.
This dialog displays a list of tables with all associated triggers.
You can right-click to enable or disable triggers during the Load
Process for each table. You can also select whether to enable or disable
the triggers after the Load Process completes.
- CONSMODE
- Override for disabling or enabling constraints. Specify:
- Never
- Do not disable referential integrity constraints for the loader.
- Always
- Disable referential integrity constraints during the Load Process
and then reenable the constraints after the process completes
- Prompt
- Display the Disabling Trigger/Constraint Confirmation dialog.
This dialog displays a list of tables with all associated constraints.
You can right-click to enable or disable constraints during the Load
Process for each table. You can also select whether to enable or disable
the constraints after the Load Process completes.
- 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.