HELP CAST Statement Attributes | Teradata Vantage - HELP CAST Attributes - Analytics Database - Teradata Vantage

SQL Data Definition Language Detailed Topics

Deployment
VantageCloud
VantageCore
Edition
Enterprise
IntelliFlex
VMware
Product
Analytics Database
Teradata Vantage
Release Number
17.20
Published
June 2022
Language
English (United States)
Last Update
2023-07-11
dita:mapPath
vuk1628111288877.ditamap
dita:ditavalPath
qkf1628213546010.ditaval
dita:id
B035-1184
lifecycle
latest
Product Category
Teradata Vantage™

The following table lists the attributes reported by the HELP CAST statement:

Attribute Data Type Nullable? Description
Source VARCHAR(31) No The name of the source type.

Because the containing database is always SYSUDTLIB, it is not reported.

Target VARCHAR(31) No The name of the target type.

Because the containing database is always SYSUDTLIB, it is not reported.

Cast Routine VARCHAR(31) No If UDT_name is a structured UDT, this is the specific name of the external routine that provides the casting functionality.

If UDT_name is a distinct UDT and its casting functionality was system-generated, this is the word System.

Because the containing database is always SYSUDTLIB, it is not reported.

As Assignment VARCHAR(3) No
  • NO specifies that the AS ASSIGNMENT option was not specified for this cast definition.

    If the code is NO, implicit casting is not supported for this external routine.

  • YES specifies that the AS ASSIGNMENT option was specified for this cast definition.

    If the code is YES, implicit casting is supported for this external routine if the value for the DisableImplCastForSysFuncOp DBS Control flag is set to 00x0.

For details, see Using the AS ASSIGNMENT Clause To Make a Cast Operation Implicitly Invokable.

Dictionary Source VARCHAR(128) No The attributes shown in this section are based upon and supersede corresponding older attributes, Source, Target, and Cast Routine, while providing additional functionality.

The older attributes are retained for compatibility with legacy applications.

For details, see the topics beginning with Object Name and Title Data in HELP Reports.

SQL Source VARCHAR(644) No
Source Uescape VARCHAR(1) Yes
Dictionary Target VARCHAR(128) No
SQL Target VARCHAR(644) No
Target Uescape VARCHAR(1) Yes
Dictionary Cast Routine VARCHAR(128) No
SQL Cast Routine VARCHAR(644) No
Cast Routine Uescape VARCHAR(1) Yes