Application programming language support

You can write applications to store XML data in DB2® databases tables, retrieve data from tables, or call stored procedures or user-defined functions with XML parameters.

You can use any of the following languages to write your applications:

• ILE RPG
• ILE COBOL
• C and C++ (embedded SQL or DB2 CLI)
• Java™ (JDBC or SQLJ)

An application program can retrieve an entire document that is stored in an XML column.

When an application provides an XML value to a DB2 database server, the database server converts the data from the XML serialized string format to an XML value with the specified CCSID.

When an application retrieves data from XML columns, the DB2 database server converts the data from the XML value, with the specified CCSID, to the XML serialized string format. In addition, the database server might need to convert the output data from the XML CCSID to the string CCSID.

When you retrieve XML data, you need to be aware of the effect of CCSID conversion on data loss. Data loss can occur when characters in the source XML CCSID cannot be represented in the target string's CCSID.

When you fetch an XML document, you retrieve the serialized form of a document into an application variable.