7.27.1 DEF_MAP_EX Parameters
NAME |
|---|
The name of the external method parameter as used within RDML.
TYPE |
|---|
Specifies the type of the parameter being defined. The permissible values are:
*BINARY indicates a Binary parameter.
*BOOLEAN indicates a Boolean parameter.
*CHAR indicates a Character parameter.
*DATE indicates a Date parameter.
*DATETIME indicates a Datetime parameter.
*FLOAT indicates a Float parameter.
*INT indicates an Integer parameter.
*NCHAR indicates an NChar parameter.
*NVARCHAR indicates an NVarChar parameter.
*PACKED indicates a Packed parameter.
*SIGNED indicates a Signed parameter.
*TIME indicates a Time parameter.
*VARBINARY indicates a VarBinary parameter.
*VARCHAR indicates a VarChar parameter.
LENGTH |
|---|
Specifies the length of the field being defined. For specific information on allowable field lengths see Field Types. Note that for types Boolean, Date & Time the length is fixed and *DEFAULT should be specified or be allowed to default.
DECIMALS |
|---|
Specifies the number of decimal positions of the parameter being defined and is used in conjunction with the types of *PACKED or *SIGNED. A value in the range 0 to the LENGTH must be specified.
All Fields of types other than Signed and Packed must have DECIMALS(0) specified.
FOR |
|---|
Specifies how the parameter is to be used by the external method. The permissible values are:
*BOTH indicates that the external method uses the parameter as both input and output.
*INPUT indicates that the external method uses the parameter as input only.
*OUTPUT indicates that the external method uses the parameter as output only.
*RESULT indicates that the external method uses the parameter as a return value. Only one of the parameters can be specified to be a return value. This can only be specified where the external method is a call to a procedure in a service program, that is, ENTRYPOINT was specified in the DEF_MTH_EX command.
FORMAT |
|---|
Specifies how the parameter is to be mapped to and/or from the external method. For each type, the permissible values are listed in the table following.
*TYPE | FORMAT | Effect |
|---|---|---|
*BINARY | *DEFAULT | As is as a buffer |
*BOOLEAN | *DEFAULT | Integer with value 0 or 1 |
*CHAR | *DEFAULT | As is as a buffer |
*DATE | *DEFAULT *DMY *EUR *ISO *JIS *JUL *MDY *USA | As is as a buffer DDsMMsYY DD.MM.CCYY CCYY-MM-DD CCYY-MM-DD YYsDDD MMsDDsYY MM/DD/CCYY |
*DATETIME | *DEFAULT | YYYY-MM-DD-HH.MM.SS.FFFFFFFFF |
*FLOAT | *DEFAULT | As is as float according to length |
*INT | *DEFAULT | As is as integer according to length |
*NCHAR | *DEFAULT | As is as a graphic buffer |
*NVARCHAR | *DEFAULT *VAR2 *VAR4 | As per *VAR2 As variable length graphic, length as 2 byte integer As variable length graphic, length as 4 byte integer |
*PACKED | *DEFAULT | As is as packed according to length |
*SIGNED | *DEFAULT | As is as signed according to length |
*VARBINARY | *DEFAULT *VAR2 *VAR4 | As per *VAR2 As variable length binary, length as 2 byte integer As variable length binary, length as 4 byte integer |
*VARCHAR | *DEFAULT *NTS *VAR2 *VAR4 | As per *VAR2 As null terminated string As variable length character, length as 2 byte integer As variable length character, length as 4 byte integer |
DATE_SEPARATOR |
|---|
Specify the date separator for the various date formats used to map to and/or from the external method. The permissible values are:
*DEFAULT indicates that the parameter is not a date or that the format does not allow a date separator to be specified.
*BLANK indicates that the blank character (" ") is to be used as the date separator. Valid for formats: *DMY, *JUL, *MDY and *YMD.
*COMMA indicates that the comma character (",") is to be used as the date separator. Valid for formats: *DMY, *JUL, *MDY and *YMD.
*DOT indicates that the dot or full stop character (".") is to be used as the date separator. Valid for formats: *DMY, *JUL, *MDY and *YMD.
*HYPHEN indicates that the hyphen or dash character ("-") is to be used as the date separator. Valid for formats: *DMY, *JUL, *MDY, and *YMD.
*SLASH indicates that the forward-slash character ("/") is to be used as the date separator. Valid for formats: *DMY, *JUL, *MDY and *YMD.
TIME_SEPARATOR |
|---|
Specifies the time separator for the various time formats that are used to map to and / or from the external method. The permissible values are:
*DEFAULT indicates that the parameter is not a time or that the format does not allow a time separator to be specified.
*BLANK indicates that the blank character (" ") is to be used as the time separator. Valid for format *HMS, only.
*COLON indicates that the colon character (":") is to be used as the time separator. Valid for format *HMS, only.
*COMMA indicates that the comma character (",") is to be used as the time separator. Valid for format *HMS, only.
*DOT indicates that the dot or full stop character (".") is to be used as the time separator. Valid for format *HMS, only.