HELP CAST Statement Attributes | Teradata Vantage - HELP CAST Attributes - Advanced SQL Engine - Teradata Database

SQL Data Definition Language Detailed Topics

Product
Advanced SQL Engine
Teradata Database
Release Number
17.10
Published
July 2021
Language
English (United States)
Last Update
2021-07-27
dita:mapPath
imq1591724555718.ditamap
dita:ditavalPath
imq1591724555718.ditaval
dita:id
B035-1184
lifecycle
previous
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