Previous Topic Next topic Print topic


XML Data Type

Many DBMS providers support XML as a data type in both character and binary formats. See your DBMS documentation for further information as to what types of host variables the vendor suggests using.

Host Variable Format

OpenESQL and DB2 ECM
01 xmlclob1-hv-name        SQL TYPE IS XML AS CLOB(2M).

The xmlclob1-hv-name format uses the XML SQL TYPE.

DB2 ECM
01 xmlblob-file1-hv-name   SQL TYPE IS XML AS BLOB-FILE.
01 xmlclob-file1-hv-name   SQL TYPE IS XML AS CLOB-FILE.
01 xmldbclob-file1-hv-name SQL TYPE IS XML AS DBCLOB-FILE.

All formats use the XML SQL TYPE.

Previous Topic Next topic Print topic