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 1. 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 OpenEdge SQL language elements.