Start of change

Encoding considerations for passing XML data in routine parameters

In a DB2® database system, several XML data types are available for parameters in a stored procedure or user-defined function definition.

The following XML data types are available:
XML
For SQL procedures and functions.
XML AS
For external procedures and external user-defined functions.

Data in XML AS parameters is subject to character conversion. Any application character or graphic data type can be used for the parameters in the calling application, but the source data should not contain an encoding declaration. Additional CCSID conversions may occur, which can make the encoding information inaccurate. If the data is further parsed in the application, data corruption can result.

Parent topic: Encoding considerations when storing or passing XML data
End of change