|
OpenEdge parameter type
|
Supported dataslot types
|
Level of support
|
|
CHARACTER
|
CHARACTER
|
Fully supported. Supported for a maximum of 30000 characters.1
|
|
INTEGER
|
Supported with string value of the dataslot passed to CHARACTER.
|
|
|
INT64
|
Supported with string value of the dataslot passed to CHARACTER.
|
|
|
DECIMAL
|
Supported with string value of the dataslot passed to CHARACTER.
|
|
|
DATETIMETZ
|
Supported with string value of the dataslot passed to CHARACTER.
|
|
|
LOGICAL
|
Supported with string value of the dataslot passed to CHARACTER.
|
|
|
CHARACTER LIST
|
LIST
|
Fully supported.
|
|
LONGCHAR
|
CHARACTER
|
Fully supported.2
|
|
DATE
|
DATETIMETZ
|
Supported for passing the date part.2
|
|
DATETIME
|
DATETIMETZ
|
Supported for passing the date and time part.2
|
|
DATETIME-TZ
|
DATETIMETZ
|
Fully supported.2.
Supports the following formats to map a constant value with a DATETIME-TZ parameter in the OpenEdge Adapter Dataslot Mapping dialog:
 "yyyy-MM-dd'T'HH:mm:ss.SSS(+/-)zz:zz" or "yyyy-MM-dd HH:mm:ss.SSS(+/-)zz:zz"
"yyyy-MM-dd'T'HH:mm:ss.SSS" or "yyyy-MM-dd HH:mm:ss.SSS"
"yyyy-MM-dd'T'HH:mm:ss" or "yyyy-MM-dd HH:mm:ss"
"yyyy-MM-dd"
For example, 1995-01-17T12:12:12.234+05:30 or 1995-01-17 12:12:12.234+05:30.
Note: The list of supported date formats specified above is applicable to these three date parameters: DATE, DATETIME, and DATETIME-TZ.
|
|
DECIMAL
|
DECIMAL
|
Supported for numbers with a maximum of 50 digits with up to 10 digits after the decimal point.2
|
|
DECIMAL
|
Fully supported.
|
|
|
INT64
|
Fully supported.
|
|
|
INTEGER
|
Fully supported.
|
|
|
HANDLE
|
Handle
|
Fully supported.
|
|
INT64
|
INT64
|
Fully supported.
|
|
INTEGER
|
Fully supported.2
|
|
|
INTEGER
|
INTEGER
|
Fully supported.2
|
|
LOGICAL
|
LOGICAL
|
Fully supported.2
|
|
MEMPTR
|
Memptr
|
Fully supported.
|
|
RAW
|
Raw
|
Fully supported.
|
|
ROWID
|
Rowid
|
Fully supported.
|
|
OpenEdge parameter type
|
Supported dataslot types
|
Level of support
|
|
CHARACTER
|
CHARACTER
|
Fully supported. Supported for a maximum of 30000 characters.1
|
|
INTEGER
|
Supported with conversion into numeric format.
|
|
|
INT64
|
Supported with conversion into numeric format.
|
|
|
DECIMAL
|
Supported with conversion into numeric format.
|
|
|
DATETIMETZ
|
Supported with conversion into numeric format.
|
|
|
LOGICAL
|
Supported with conversion into numeric format.
|
|
|
CHARACTER LIST
|
LIST
|
Fully supported.
|
|
LONGCHAR
|
CHARACTER
|
Supported for a maximum of 256 characters for a STRING of CHAR type and 2000 characters for a STRING of VARCHAR type.3
|
|
DATE
|
DATETIMETZ
|
Fully supported.3
|
|
DATETIME
|
DATETIMETZ
|
Fully supported.3
|
|
DATETIME-TZ
|
DATETIMETZ
|
Supported for passing the date and the time part.3
|
|
DECIMAL
|
DECIMAL
|
Supported for numbers with a maximum of 50 digits with up to 10 digits after the decimal point.3
|
|
HANDLE
|
Handle
|
Fully supported.
|
|
DECIMAL
|
DECIMAL
|
Fully supported.3
|
|
INT64
|
INT64
|
Fully supported.
|
|
DECIMAL
|
Fully supported.
|
|
|
INTEGER
|
INTEGER
|
Fully supported.3
|
|
DECIMAL
|
Fully supported.1
|
|
|
INT64
|
Fully supported.
|
|
|
LOGICAL
|
LOGICAL
|
Fully supported.3
|
|
MEMPTR
|
Memptr
|
Fully supported.
|
|
RAW
|
Raw
|
Fully supported.
|
|
ROWID
|
Rowid
|
Fully supported.
|