The following syntax is used to generate a statement for
each exported Insert Request definition:
Keywords
The
keywords correspond to values that can be specified for an Insert
Request. See the Move User Manual or the Archive User Manual .
- UPIN identifier.name
- The name of the Insert Request, specified in two
parts (identifier.name) is required following the CREATE
UPIN keyword.
- DESC //description//
- A description of the Insert Request, delimited by
double slashes.
General
- XF xfilname
- The fully qualified name of the Extract File or
Archive File used as input for the Insert Process.
- CF cfilname
- The fully qualified name of the Control File for
the Insert Process.
Table Map Keywords
A Table
Map parameter must be included. The Table Map can be Local or Named.
If the keyword is LOCALTM, the Table Map is
Local. The full definition of the Table Map follows, contained in
parentheses. If the keyword is TM, the Table
Map is Named and the name follows the keyword.
- LOCALTM (tmdef)
- The definition of a Local Table Map, enclosed in parentheses.
For details on specifying Table Maps, see Table Maps.
- TM tmname
- The two-part name (identifier.name) of the Named Table Map.
Keywords
- DISCARDLIMIT n
- The maximum number of rows (n)
that can be discarded.
- COMMITFREQ n
- The frequency (every nth row)
at which commits are issued.
- FORCEEDITTM {Y|N}
- (Always View Table Map) indicates
whether the Table Map Editor opens automatically
when processing an Insert Request.
- Y
- The Table Map Editor opens
automatically.
- N
- The Table Map Editor does
not open automatically.
- LOCKTBLS {Y|N}
- (Lock Tables) indicates whether
tables are locked during the Insert.
- Y
- Tables are locked.
- N
- Tables are not locked.
- UPDINS {U|I|M}
- Indicates the type of Insert performed.
- U
- Update/Insert
- I
- Insert
- M
- Mixed
Note: The specifications for particular tables selected
for updating (using the Insert Table Specification dialog) are included
in the TBL keywords.
- DELETEROWS {A|M|N}
- Indicates the type of delete performed as part of
the Insert.
- A
- All tables
- M
- Selected tables
- N
- Do not delete
Note: The tables selected for delete using the Insert
Table Specification dialog are included in the TBL keywords.
- DELCOMMIT {E|C}
- Indicates the COMMIT frequency when rows are deleted
during an Insert.
- E
- After each table
- C
- On completion
- ALWAYSCALLCREATE {Y|N}
- Indicates whether the Create dialog
displays each time.
- Y
- Create dialog displays.
- N
- Create dialog displays when
needed.
- TRIGMODE {A|P|N}
- TRIGMODE indicates whether
triggers are disabled.
- A
- Always
- P
- Prompt for specific triggers
- N
- Never
- CONSMODE {A|P|N}
- Indicates whether constraints are disabled
- A
- Always
- P
- Prompt for specific constraints.
- N
- Never
- SHOWCURRENCY {Y|N}
- Indicates whether the Currency tab
displays.
- Y
- Currency tab displays.
- N
- Currency tab does not display.
- SHOWAGE {Y|N}
- Indicates whether the Aging tabs
display.
- Y
- Age Function and Global Aging tabs display.
- N
- Age Function and Global Aging tabs do not display.
- PROCESS_ FILEATTACH {Y|N}
- Indicates if file attachments in the Archive or
Extract File are processed.
Age Function
If
options for aging are specified, they follow the FUNCTION_AGING keyword
in parentheses.
- FUNCTION_AGING
- Indicates date aging is used for the Insert.
- AGETYPE type
- The function type specified as one of the following:
NONE |
SPECIFICDATE |
INCREMENTAL |
TARGETDATES |
SPECIFICYEAR |
RULEBASED |
- YEARS nn
- The positive or negative numeric value (nn)
to age the date by years.
- MONTHS nn
- The positive or negative numeric value (nn)
to age the date by months.
- WEEKS nn
- The positive or negative numeric value (nn) to
age the date by weeks.
- DAYS nn
- The positive or negative numeric value (nn) to
age the date by days.
- SPECIFICYEAR nnnn
- An explicit year (nnnn) to which
Insert should age.
- SPECIFICDATE mm/dd/yyyy
- The date (mm/dd/yyyy) to which
Insert should age.
- TARGETSTART mm/dd/yyyy
- The date (mm/dd/yyyy) Insert
should use as the starting date when calculating the amount to age
using relative aging.
- TARGETEND mm/dd/yyyy
- The date (mm/dd/yyyy) Insert
should use as the target date when calculating the amount to age using
relative aging.
- MULTIPLE nn
- The number of times (nn) Insert
should apply a rule to determine the aging amount.
- RULE rulename
- The name of the rule (rulename)
being used.
- CALENDAR calendarname
- The name of the calendar (calendarname)
being used.
- PIVOT nn
- The pivot year (nn).
- INVALIDDATES {Y|N}
- Indicates whether to insert rows with dates that
are invalid to use.
- SKIPPEDDATES {Y|N}
- Indicates whether to insert rows with dates that
should be skipped.
Global Aging
If
options for function aging are specified, they follow the GLOBAL_AGING
keyword in parentheses.
- GLOBAL_AGING
- Indicates global date aging is used for the Insert.
- AGETYPE type
- The function type specified as one of the following:
NONE |
SPECIFICDATE |
INCREMENTAL |
TARGETDATES |
SPECIFICYEAR |
RULEBASED |
- YEARS nn
- The positive or negative numeric value (nn)
to age the date by years.
- MONTHS nn
- The positive or negative numeric value (nn)
to age the date by months.
- WEEKS nn
- The positive or negative numeric value (nn)
to age the date by weeks.
- DAYS nn
- The positive or negative numeric value (nn)
to age the date by days.
- SPECIFICYEAR nnnn
- An explicit year (nnnn) to which
Insert should age.
- SPECIFICDATE mm/dd/yyyy
- The date (mm/dd/yyyy) to which
Insert should age.
- TARGETSTART mm/dd/yyyy
- The date (mm/dd/yyyy) Insert
should use as the starting date when calculating the amount to age
using relative aging.
- TARGETEND mm/dd/yyyy
- The date (mm/dd/yyyy) Insert
should use as the target date when calculating the amount to age using
relative aging.
- MULTIPLE nn
- The number of times (nn) Insert
should use a rule to determine the aging amount.
- RULE rulename
- The name of the rule (rulename)
being used.
- CALENDAR calendarname
- The name of the calendar (calendarname)
being used.
- PIVOT nn
- The pivot year (nn).
- INVALIDDATES {Y|N}
- Indicates whether to Insert rows that have dates
that are invalid to use.
- SKIPPEDDATES {Y|N}
- Indicates whether to Insert rows that have dates
that should be skipped.
Report Options
If
Report options are specified, they follow the REPORT_OPTION keyword
in parentheses.
- REPORT_OPTION
- Indicates reporting options are used for the Insert.
- RPTERROR {T|F}
- Indicates whether to report errors
(True or False).
- MAXTBLERR nnn
- The maximum number (nnn) of errors
per table to report.
- MAXRUNERR nnn
- The maximum number (nnn) of errors
per run to report.
- RPTSUMMARY {T|F}
- Indicates whether to report the Aging summary (True
or False).
- RPTINVALID {T|F}
- Indicates whether to report invalid dates (True
or False).
- RPTSKIPPED {T|F}
- Indicates whether to report skipped dates (True
or False).
Currency
If
options for currency conversion are specified, they follow the CURRENCY_OPTION
keyword in parentheses.
- CURRENCY_OPTION
- Indicates options for currency conversion are used
for the Insert.
- DEFAULT currencytablename
- The name of the default Currency Table (currencytablename)
being used.
- GLOBAL currencytablename
- The name of the global Currency Table (currencytablename)
being used.
- FROM currencytype
- The three character code for the source currency
type (currencytype).
- TO currencytype
- The three character code for the target currency
type (currencytype).
- TRIANG {T|F}
- Indicates whether to convert currency via the euro
dollar (True or False).
Table Keywords
There
is a TBL entry for every table in the Table Map. The set of keywords
for each table is enclosed in parentheses following the keyword “TBL.”
The keywords correspond to values specified both on the General tab
of the Insert Request Editor and on the Insert
Table Specification dialog.
- tblname
- The name of the table is required.
- DELETEROWS {Y|N}
- Indicates whether the rows in the table should be
deleted prior to the insertion of new rows.
- Y
- Rows should be deleted prior to insertion.
- N
- Rows should not be deleted prior to insertion
- UPDINS {Y|N}
- Indicates whether the rows in the table should be
updated and inserted or inserted without updating.
- Y
- Update and insert.
- N
- Insert only, do not update.
- STATUS {O|D|N|T}
- Indicates the Table Map status for the table.
- O
- The table exists in the database.
- D
- A new table using default settings.
- N
- A new table for which options must be specified
(because of the specifications for Mixed Insert or Selective Delete).
- T
- A table that is not used, because it is not in
the Table Map.
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.
File Attachments
The FILE_ATTACH keyword
relates to the Directory Map paths.
- DEFAULT (//path//)
- The default destination path.
- PATHMAP (//srcpath//destpath//)
- The source and destination paths. Use this keyword
for each source and destination pair.