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.