Data Type Encoding Numbers for the XML Type

Teradata Vantageā„¢ XML Data Type

brand
Software
Teradata Vantage
prodname
Teradata Database
Teradata Vantage NewSQL Engine
vrm_release
16.20
category
Programming Reference
featnum
B035-1140-162K

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