16.20 - Data Type Encoding Numbers for the XML Type - Teradata Database - Teradata Vantage NewSQL Engine

Teradata Vantage™ XML Data Type

Teradata Database
Teradata Vantage NewSQL Engine
Release Number
Release Date
March 2019
Content Type
Programming Reference
Publication ID
English (United States)

Some of the client and server interfacing parcels such as DataInfoX (parcel flavor number 146), PrepInfoX (flavor 125), and StatementInfo parcel (flavor 169) return the data type of the field. All parcels that contain the data type information use the following encoding for the XML data type. The encoding numbers defined follow the pattern for existing data types. For example, Nullable number is non-Nullable value + 1 and stored procedure IN parameter type number is 500 + non-nullable number.

  NULL Property Stored Procedure Parameter Type
Non-nullable Nullable IN INOUT OUT
XML Text Inline - for small XML values 852 853 1352 1353 1354
XML Text Deferred 856 857 1356 1357 1358
XML Text Locator 860 861 1360 1361 1362