7.27.1 DEF_MAP_EX Parameters

DATE_SEPARATOR

DECIMALS

ENTRYPOINT

FOR

FORMAT

LENGTH

NAME

TIME_SEPARATOR

TYPE

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 (where FFFFFFFFF is 0 -9 occurrences depending on length) as a buffer *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

Specifies the date separator for the various date 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 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.