The following syntax is used to generate a statement for
each exported Convert Request definition:
Keywords
The
keywords correspond to values that can be specified for a Convert
Request. For additional information about an individual parameter,
see the Move User Manual .
- CONV identifier.name
- The name of the Convert Request, specified in two
parts (identifier.name), is required following
the CREATE CONV keyword.
- DESC //description//
- A description of the Convert Request, delimited
by double slashes.
General
- SRCXF srcxfname
- The fully qualified name of the Source Extract File
used as input for the Convert Process.
- DESTXF destxfname
- The fully qualified name of the Destination Extract
File to be the output of the Convert Process.
- CF cfname
- The fully qualified name of the Control File for
the Convert Process.
- LOCALTM (localtmdef)
- The definition of a Local Table Map, enclosed in
parentheses. For details on specifying Table Maps, see Table Maps.
- TM tmname
- The name of the Named Table Map for the Convert
Request. The name of the Table Map follows the keyword.
- DISCARDLIMIT n
- (Discard Row Limit) indicates
a limit (n) for discarded rows, if one is included.
- COMPRESSFILE {Y|N}
- Indicates whether to compress the Destination Extract
File after processing.
- INCL_FILEATTACH {Y|N}
- Indicates whether to include file attachments in
the destination file. File attachments are not converted.
- FORCEEDITTM {Y|N}
- (Always View Table Map) indicates
whether the Table Map Editor opens automatically
when processing the Convert Request.
- Y
- The Table Map Editor opens
automatically.
- N
- The Table Map Editor does
not open automatically.
- 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
Age Function
If
options for the Aging function are specified, they follow the FUNCTION_AGING
keyword in parentheses.
- FUNCTION_AGING
- Indicates date aging function is used for the Convert.
- AGETYPE agetype
- The function type specified as one of the following:
NONE
INCREMENTAL
SPECIFICYEAR
SPECIFICDATE
TARGETDATES
RULEBASED
- YEARS nn
- The positive or negative numeric value (nn)
to age the date by years for incremental aging.
- MONTHS nn
- The positive or negative numeric value (nn)
to age the date by months for incremental aging.
- WEEKS nn
- The positive or negative numeric value (nn) to
age the date by weeks for incremental aging.
- DAYS nn
- The positive or negative numeric value (nn)
to age the date by days for incremental aging.
- SPECIFICYEAR nnnn
- An explicit year (nnnn) to which
the Convert should age.
- SPECIFICDATE mm/dd/yyyy
- The date (mm/dd/yyyy) to which
the Convert should age.
- TARGETSTART mm/dd/yyyy
- The date (mm/dd/yyyy) Convert
should use as the starting date when calculating the amount to age
using relative aging.
- TARGETEND mm/dd/yyyy
- The date (mm/dd/yyyy) Convert
should use as the target date when calculating the amount to age using
relative aging.
- MULTIPLE nn
- The number of times (nn) Convert
should apply a rule for date aging.
- 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 Convert rows with dates that
are invalid to use.
- SKIPPEDDATES {Y|N}
- Indicates whether to Convert rows with dates that
should be skipped.
Global Aging
If
options for global aging are specified, they follow the GLOBAL_AGING
keyword in parentheses.
- GLOBAL_AGING
- Indicates global date aging is used in conversion.
- AGETYPE agetype
- The function type specified as one of the following:
NONE
INCREMENTAL
SPECIFICYEAR
SPECIFICDATE
TARGETDATES
RULEBASED
- YEARS nn
- The positive or negative numeric value (nn)
to age the date by years for incremental aging.
- MONTHS nn
- The positive or negative numeric value (nn)
to age the date by months for incremental aging.
- WEEKS nn
- The positive or negative numeric value (nn)
to age the date by weeks for incremental aging.
- DAYS nn
- The positive or negative numeric value (nn)
to age the date by days for incremental aging.
- SPECIFICYEAR nnnn
- An explicit year (nnnn) to which
the Convert should age.
- SPECIFICDATE mm/dd/yyyy
- The date (mm/dd/yyyy) to which
the Convert should age.
- TARGETSTART mm/dd/yyyy
- The date (mm/dd/yyyy) Convert
should use as the starting date when calculating the amount to age
using relative aging.
- TARGETEND mm/dd/yyyy
- The date (mm/dd/yyyy) Convert
should use as the target date when calculating the amount to age using
relative aging.
- MULTIPLE nn
- The number of times (nn) Convert
should apply a rule for date aging.
- 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 process rows with dates that
are invalid to use.
- SKIPPEDDATES {Y|N}
- Indicates whether to process rows with 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 Convert.
- 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 Convert.
- 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).
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.
Comma Separated
If
options for creating a Comma Separated file are specified, they follow
the CSF keyword in parentheses.
- CSF
- Indicates a Comma Separated file is specified.
- TABLE
- This keyword precedes each fully qualified table
name listed on the Comma Separated tab of the
Convert Request. The table name is followed by additional keywords
to indicate the relationship between the joined tables.
- OUTCOLS
- The names of any columns from the listed table
included in each outputted row of the Comma Separated file.
- OUTPOSITION
- The relative position of each column
in the outputted row of the Comma Separated file.