Each row contains reverse data type mappings (mappings from data types defined locally to data source data types). No data in this version. Defined for possible future use with data type mappings.
Table 103. SYSCAT.REVTYPEMAPPINGS Catalog View
Column Name | Data Type | Nullable | Description |
---|---|---|---|
TYPE_MAPPING | VARCHAR(18) |
| Name of the reverse type mapping (may be system-generated). |
TYPESCHEMA | VARCHAR(128) | Yes | Schema name of the type. Null for system built-in types. |
TYPENAME | VARCHAR(18) |
| Name of the local type in a reverse type mapping. |
TYPEID | SMALLINT |
| Type identifier. |
SOURCETYPEID | SMALLINT |
| Source type identifier. |
DEFINER | VARCHAR(128) |
| Authorization ID under which this type mapping was created. |
LOWER_LEN | INTEGER | Yes | Lower bound of the length/precision of the local type. |
UPPER_LEN | INTEGER | Yes | Upper bound of the length/precision of the local type. If null then the system determines the best length/precision attribute. |
LOWER_SCALE | SMALLINT | Yes | Lower bound of the scale for local decimal data types. |
UPPER_SCALE | SMALLINT | Yes | Upper bound of the scale for local decimal data types. If null, then the system determines the best scale attribute. |
S_OPR_P | CHAR(2) | Yes | Relationship between local scale and local precision. Basic comparison operators can be used. A null indicates that no specific relationship is required. |
BIT_DATA | CHAR(1) | Yes |
|
WRAPNAME | VARCHAR(128) | Yes | Mapping applies to this data access protocol. |
SERVERNAME | VARCHAR(128) | Yes | Name of the data source. |
SERVERTYPE | VARCHAR(30) | Yes | Mapping applies to this type of data source. |
SERVERVERSION | VARCHAR(18) | Yes | Mapping applies to this version of SERVERTYPE. |
REMOTE_TYPESCHEMA | VARCHAR(128) | Yes | Schema name of the remote type. |
REMOTE_TYPENAME | VARCHAR(128) |
| Name of the data type as defined on the data source(s). |
REMOTE_META_TYPE | CHAR(1) | Yes |
|
REMOTE_LENGTH | INTEGER | Yes | Maximum number of digits for remote decimal type, and maximum number of characters for remote character type. Otherwise null. |
REMOTE_SCALE | SMALLINT | Yes | Maximum number of digits allowed to the right of the decimal point (for remote decimal types). Otherwise null. |
REMOTE_BIT_DATA | CHAR(1) | Yes |
|
USER_DEFINED | CHAR(1) |
| Defined by user. |
CREATE_TIME | TIMESTAMP |
| Time when this mapping was created. |
REMARKS | VARCHAR(254) | Yes | User supplied comments, or null. |