Data Type Encoding Numbers for the XML Type | Teradata Vantage - 17.10 - Data Type Encoding Numbers for the XML Type - Advanced SQL Engine - Teradata Database

Teradata Vantageā„¢ - XML Data Type

Product
Advanced SQL Engine
Teradata Database
Release Number
17.10
Release Date
July 2021
Content Type
Programming Reference
Publication ID
B035-1140-171K
Language
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