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

Teradata Vantage™ - SQL Data Definition Language Detailed Topics

Product
Advanced SQL Engine
Teradata Database
Release Number
17.10
Release Date
July 2021
Content Type
Programming Reference
Publication ID
B035-1184-171K
Language
English (United States)

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