This topic lists the override parameters available for
an Insert Process.
- XFFILE
- Override for the Extract File referenced by the
Insert 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
Insert 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 Insert
Request.
- identifier.tablemap name
- Two-part name of an existing Table Map.
- COMMFREQ
- Override for the frequency for committing processed
rows to the database for the Insert Process.
- n
- A numeric value to specify the maximum number of
rows to extract from a table. Valid values are 1 through the maximum
set in Product Options.
- PROCTYPE
- Override for the type of Insert Processing to use.
- INS
- Insert new rows into the tables during the Insert
Process.
- UPDINS
- Update and insert rows in tables during the Insert
Process.
- LOCKTABS
- Override for the Lock Tables setting in the Insert
Request.
- Y
- Lock each table until all rows in the Extract File
for that table are processed.
- N
- Do not lock the tables.
- DISROWLIM
- Override for Discard Row Limit setting in the Insert
Request.
- n
- 0 (to impose no limit) or a number from 1 to 99999999
to stop processing after the specified number of rows are discarded
and all rows in the array processed. You can Restart or Retry a process
that stops because the limit is reached.
- COLMAPID
- Override for the default identifier for the Column
Maps included in the Table Map.
- identifier
- The 1 to 8 character identifier.
- COLMAP
- Override for the Column Map name for a specific
table in the Table Map.
Note: 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.
- 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.