The following syntax is used to generate a statement for
each exported Compare Request definition:
Keywords
The
keywords correspond to values that can be specified for a Compare
Request. For more information about individual parameters, see the Compare
User Manual .
- COMP identifier.name
- The name of the Compare Request, specified in two
parts (identifier.name), is required following
the CREATE COMP keyword.
- DESC //description//
- A description of the Compare Request, delimited
by double slashes.
- SRCTYPE srctype
- Indicates S or M for single or multiple tables,
and then E for Extract File, A for Access Definition, or D for database
tables for each source. (For example, “MAA” indicates Multiple
tables, comparing a Source 1 Access Definition to a Source
2 Access Definition.)
- SRC1XF src1xfname
- The fully qualified name of the Source 1 Extract
File used as input for the Compare Process.
- SRC2XF src2xfname
- The fully qualified name of the Source 2 Extract
File used as input for the Compare Process.
- CMF cmpname
- The fully qualified name of the Compare File for
the Compare Process.
- BROWSERESULTS {Y|N}
- Indicates whether the Browse dialog
opens immediately upon completion of the Compare Process.
- Y
- The Browse dialog opens automatically.
- N
- The Browse dialog does not
open automatically.
- CREATEREPORT {Y|N}
- Indicator for whether to create a Report on the
Compare File after processing.
- EXTRACTRUNMODE {S|P}
- When both Source 1 and Source 2 require an Extract
Process to be performed, EXTRACTRUNMODE (Run
Mode for Extract) indicates whether the two Extract Processes should
run in sequence or parallel.
- S
- Run the Extract Processes in sequence (one, then
the other).
- P
- Run the Extract Processes in parallel (both at
the same time).
- FORCEEDITTM {Y|N}
- (Always View Table Map) indicates
whether the Table Map Editor opens automatically
when processing the Compare Request.
- Y
- The Table Map Editor opens
automatically.
- N
- The Table Map Editor does
not open automatically.
- LOCALTM (localtmdef)
- The definition of a Local Table Map, enclosed in
parentheses.
- TM tmname
- The name of the Named Table Map for the Compare
Request. The name of the Table Map follows the keyword.
- LOCALAD1
- A full definition of the Local Access Definition
for Source 1 (or Source 2), contained in parentheses, follows this
keyword.
- LOCALAD2
- A full definition of the Local Access Definition
for Source 1 (or Source 2), contained in parentheses, follows this
keyword.
- AD1
- The full two-part name of the Named Access Definition
for Source 1 (or Source 2) for the Compare Request. The name of the
Access Definition follows the keyword.
- AD2
- The full two-part name of the Named Access Definition
for Source 1 (or Source 2) for the Compare Request. The name of the
Access Definition follows the keyword.
- MATCHKEY (matchkeydef)
- The Source 1 table name(s) and column name(s), enclosed
in parentheses, used in the match key definition.
Report Keywords
The
optional Report parameter can be defined as Local or Named:
- REPORT id.name
- The full two-part name of the Named Report Request
Definition being used.
- LOCALREPORT (reportdef)
- A full definition of the Local Report being used,
contained in parentheses, follows this keyword. The syntax and parameters
for the definition of a Local Report are identical to those for a
Named Report Request.
Notify
This
parameter relates to the ability to send notification via email about
the outcome of the process.
- EMAILNOTIFY {A|S|F} emailaddress
- Indicates the process outcome under which to send
notification to the corresponding email address.
- A
- Always send notification.
- S
- Send notification when process succeeds.
- F
- Send notification when process fails.