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 |
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 |