Try OpenEdge Now
skip to main content
SQL Reference
SQL Reference : Data Type Compatibility : Supported ABL data types and corresponding OpenEdge SQL data types
 

Supported ABL data types and corresponding OpenEdge SQL data types

OpenEdge SQL supports many data types that do not correspond to ABL data types. The following table lists the ABL data types that do correspond to OpenEdge SQL data types.
Table 49. ABL an6d corresponding OpenEdge SQL data types
ABL data type
OpenEdge SQL data type
ARRAY
VARARRAY
BLOB
BLOB
CHARACTER
VARCHAR
CLOB
CLOB
DATE
DATE
DATETIME
TIMESTAMP
DATETIME-TZ
TIMESTAMP WITH TIME ZONE
DECIMAL
DECIMAL or NUMERIC
INTEGER
INTEGER
INT64
BIGINT
LOGICAL
BIT
RAW
VARBINARY
RECID
RECID

Notes

*All other SQL types are not compatible with ABL. In particular, OpenEdge SQL CHARACTER data is not compatible with the ABL. Use OpenEdge SQL type VARCHAR to map ABL CHARACTER data.
*Data columns created using OpenEdge SQL that have a data type not supported by ABL are not accessible through ABL applications and utilities.
*For more information about OpenEdge SQL data types, see OpenEdgeSQL Language Elements.