Default mappings between ABL data types and XML Schema data types

The following table shows the default mapping between ABL data types and XML Schema data types used with the read and write XML methods of temp-tables and ProDataSets. The third column shows the ABL-specific XML Schema data type attribute which is an extension to the basic XML Schema. This attribute is used for ABL data types that are not the default for the XML Schema data type.

The table contains the most common XML Schema data types and their corresponding ABL data types.

Table 1. ABL data types mapped to XML Schema data types
ABL type XML Schema type attribute ABL-specific XML Schema data type attribute
BLOB base64Binary prodata:blob
CHARACTER string —
CLOB string prodata:clob
COM-HANDLE long prodata:comHandle
DATE date —
DATETIME dateTime prodata:dateTime
DATETIME-TZ dateTime —
DECIMAL decimal —
INT64 long —
INTEGER (32 bit) int —
LOGICAL boolean —
RAW base64Binary —
RECID (32 or 64 bit) long prodata:recid
ROWID base64Binary prodata:rowid
HANDLE/WIDGET-HANDLE long prodata:handle
Note: The -noint64 startup parameter forces ABL to use the mapping of xsd:long to ABL DECIMAL. You have some control over default data type mappings. The READ-XML( ) and READ-XMLSCHEMA( ) methods have override-default-mapping and field-type-mapping options. See Read and Write XML Data from Temp-Tables and ProDataSets.