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 2 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.