Override Keywords: Extract Process
This topic lists the override parameters available for an Extract Process.
- ADNAME
- Override for the Access Definition. A named Access
Definition overrides a local or named Access Definition in the Extract
Request.
- identifier.adname
- Two-part name of an existing Access Definition.
- DEFQUAL
- Override for the default qualifier for tables named
in the Access Definition.
- dbalias. [creatorid]
- The one or two-part qualifier (DB Alias and Creator ID) for the tables in the Access Definition.
- PNSFILE
- Override for the Point and Shoot file to use.
- pnsfilename.pns
- The name of the point and shoot file.
- ROWLIMIT
- Override for the maximum number of rows to extract.
- n
- The maximum number of rows to be extracted.
The Row Limit for an Extract Process is a number from 1 to the maximum limit specified in Product Options.
- SEL
- Override for the selection criteria specified for
a specific table. Selection criteria must conform to SQL syntax and
must include a column name, a relational operator, and a value. You
can specify multiple selection criteria, each on a separate line.
- [ [ dbalias . ] cid . ] tablename
- One, two, or three-part tablename. If tablename is not fully qualified, the default qualifier is used.
- columnname
- Name of column to which criteria applies.
- operator
- Logical operator appropriate for your DBMS.
- value
- Value or list of values appropriate for the operator, expressed as literals or substitution variables (:variablename)
- SQL
- Override for the SQL statement associated with a
table in the Access Definition. Each statement must be on a separate
line. Note: The SQL statement must conform to SQL syntax.
- [ [ dbalias . ] cid . ] tablename
- One, two, or three-part tablename. If tablename is not fully qualified, the default qualifier is used.
- sqlwhereclause
- The SQL WHERE clause associated with the table.
- TABEVERYNTH
- Override for a numeric value to specify a sampling
factor for a specified table in the Access Definition.
- [ [ dbalias . ] cid . ] tablename
- One, two, or three-part tablename. If tablename is not fully qualified, the default qualifier is used.
- value
- A numeric value to specify a sampling factor for a table. Valid values are 1 through 9999.
- TABROWLIM
- Override for a numeric value to limit the number
of rows extracted from a specified table in the Access Definition.
- [ [ dbalias . ] cid . ] tablename
- One, two, or three-part tablename. If tablename is not fully qualified, the default qualifier is used.
- value
- A numeric value to specify the maximum number of rows to extract from a table. Valid values are 1 through 99999999.
- STARTTAB
- Override for the name of the Start Table associated
with the Access Definition.
- [ [ dbalias . ] cid. ] tablename
- One, two, or three-part table name.
If the table name is not fully qualified, the default qualifier is used.
- VAR
- Override for the value in substitution variable
used in the process.
- variablename
- Name of the substitution variable.
- value
- The corresponding value for the variable.
- XFFILE
- Override for the Extract File name in the Extract
Request.
- xffile.xf
- The name of the Extract File. Provide the full path if the file is not in the default directory.