Compare Requests

The following syntax is used to generate a statement for each exported Compare Request definition:

CREATE COMP identifier.name 
   [DESC //description//] 
   SRCTYPE srctype 
   SRC1XF src1xfname SRC2XF src2xfname CMF cmpname 
   BROWSERESULTS {Y|N} 
   CREATEREPORT {Y|N} 
   EXTRACTRUNMODE {S|P} 
   FORCEEDITTM {Y|N} 
   {LOCALTM (localtmdef) | TM tmname} 
   {LOCALAD1 (localad1def) | AD1 ad1name} 
   {LOCALAD2 (localad2def) | AD2 ad2name} 
   MATCHKEY (matchkeydef)
   [{REPORT id.name | LOCALREPORT (reportdef)}]
   [EMAILNOTIFY ({A|S|F} emailaddress)];

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.