Override Keywords: Insert Process

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.