Insert Requests

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

CREATE UPIN identifier.name
   [DESC //description//] 
   XF xfilname CF cfilname {LOCALTM (tmdef) | TM tmname} 
   DISCARDLIMIT n COMMITFREQ n FORCEEDITTM {Y|N} 
   LOCKTBLS {Y|N} UPDINS {U|I|M} 
   DELETEROWS {A|M|N} 
   [DELCOMMIT {E|C}] ALWAYSCALLCREATE {Y|N} 
   TRIGMODE{A|P|N} CONSMODE{A|P|N}
   SHOWCURRENCY{Y|N} 
   SHOWAGE {Y|N}  PROCESS_ FILEATTACH {Y|N}
   [FUNCTION_AGING (AGETYPE {NONE | INCREMENTAL | 
      SPECIFICYEAR | SPECIFICDATE | TARGETDATES | 
      RULEBASED} [YEARS nn] [MONTHS nn] 
      [WEEKS nn] [DAYS nn] [SPECIFICYEAR nnnn] 
      [SPECIFICDATE mm/dd/yyyy] 
      [TARGETSTART mm/dd/yyyy TARGETEND mm/dd/yyyy] 
      [MULTIPLE nn] [RULE rulename] 
      [CALENDAR calendarname] 
      [PIVOT nn] [INVALIDDATES {Y|N}] 
      [SKIPPEDDATES {Y|N}])]
   [GLOBAL_AGING (AGETYPE {NONE | INCREMENTAL | 
      SPECIFICYEAR | SPECIFICDATE | TARGETDATES | 
      RULEBASED} [YEARS nn] [MONTHS nn] [WEEKS nn]
      [DAYS nn] [SPECIFICYEAR nnnn] 
      [SPECIFICDATE mm/dd/yyyy] 
      [TARGETSTART mm/dd/yyyy TARGETEND mm/dd/yyyy] 
      [MULTIPLE nn] [RULE rulename] 
      [CALENDAR calendarname] 
      [PIVOT nn] [INVALIDDATES {Y|N}] 
      [SKIPPEDDATES {Y|N}])]
   [REPORT_OPTION (RPTERROR {T|F} [MAXTBLERR nnn] 
      [MAXRUNERR nnn] [RPTSUMMARY{T|F}]
      [RPTINVALID{T|F}]
      [RPTSKIPPED {T|F}])]
   [CURRENCY_ OPTION (DEFAULT currencytablename 
      [GLOBAL currencytablename] [FROM currencytype] 
      [TO currencytype] [TRIANG {T|F}])]
   TBL (tblname DELETEROWS {Y|N} UPDINS {Y|N} 
      STATUS {O|D|N|T}) 
   [EMAILNOTIFY ({A|S|F} emailaddress)]
   DEFAULT (DEFAULT //path//
      PATHMAP (//srcpath//  //destpath//) ) ;

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.