Convert Requests

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

CREATE CONV identifier.name 
   [DESC //description//] 
   SRCXF srcxfname DESTXF destxfname 
   CF cfname {LOCALTM (localtmdef) | TM tmname} 
   [DISCARDLIMIT n]
   COMPRESSFILE {Y|N} 
   INCL_FILEATTACH {Y|N}
   FORCEEDITTM{Y|N}SHOWCURRENCY{Y|N} 
   SHOWAGE {Y|N} 
   [FUNCTION_AGING (AGETYPE agetype 
      [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 agetype 
      [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}])]
   [EMAILNOTIFY ({A|S|F} emailaddress)]
   [CSF (TABLE (tablename OUTCOLS (columnname) 
      OUTPOSITION (n))];

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.