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.
