SYSCAT.TYPEMAPPINGS catalog view
Each row represents a data type mapping
between a locally-defined data type and a data source data type. There
are two mapping types (mapping directions):
forward
type mappings map a data source data type to a locally-defined
data type; reverse type mappings map a locally-defined data
type to a data source data type.
Column Name | Data Type | Nullable | Description |
---|---|---|---|
TYPE_MAPPING | VARCHAR (18) | Name of the type mapping (might be system-generated). | |
MAPPINGDIRECTION | CHAR (1) | Indicates whether this type mapping is a forward or a reverse
type mapping.
|
|
TYPESCHEMA | VARCHAR (128) | Y | Schema name of the local type in a data type mapping; the null value for built-in types. |
TYPENAME | VARCHAR (128) | Unqualified name of the local type in a data type mapping. | |
TYPEID | SMALLINT | Identifier for the data type. | |
SOURCETYPEID | SMALLINT | Identifier for the source type. | |
OWNER | VARCHAR (128) | Authorization ID of the owner of the type mapping. 'SYSIBM' indicates a built-in type mapping. | |
OWNERTYPE | CHAR (1) |
|
|
LENGTH | INTEGER | Y | Maximum length or precision of the local data type in this mapping. If the null value, the system determines the maximum length or precision. For character types, represents the maximum number of bytes. |
SCALE | SMALLINT | Y | Maximum number of digits in the fractional part of a local decimal value or the maximum number of digits of fractional seconds of a local TIMESTAMP value in this mapping. If the null value, the system determines the maximum number. |
LOWER_LEN | INTEGER | Y | Minimum length or precision of the local data type in this mapping. If the null value, the system determines the minimum length or precision. For character types, represents the minimum number of bytes. |
UPPER_LEN | INTEGER | Y | Maximum length or precision of the local data type in this mapping. If the null value, the system determines the maximum length or precision. For character types, represents the maximum number of bytes. |
LOWER_SCALE | SMALLINT | Y | Minimum number of digits in the fractional part of a local decimal value or the minimum number of digits of fractional seconds of a local TIMESTAMP value in this mapping. If the null value, the system determines the minimum number. |
UPPER_SCALE | SMALLINT | Y | Maximum number of digits in the fractional part of a local decimal value or the maximum number of digits of fractional seconds of a local TIMESTAMP value in this mapping. If the null value, the system determines the maximum number. |
S_OPR_P | CHAR (2) | Y | Relationship between the scale and precision of a local decimal value in this mapping. Basic comparison operators (=, <, >, <=, >=, <>) can be used. A null value indicates that no specific relationship is required. |
BIT_DATA | CHAR (1) | Y | Indicates whether or not this character type is for bit data.
Possible values are:
|
WRAPNAME | VARCHAR (128) | Y | Data access protocol (wrapper) to which this mapping applies. |
SERVERNAME | VARCHAR (128) | Y | Uppercase name of the server. |
SERVERTYPE | VARCHAR (30) | Y | Type of server. |
SERVERVERSION | VARCHAR (18) | Y | Server version. |
REMOTE_TYPESCHEMA | VARCHAR (128) | Y | Schema name of the data source data type. |
REMOTE_TYPENAME | VARCHAR (128) | Unqualified name of the data source data type. | |
REMOTE_META_TYPE | CHAR (1) | Y | Indicates whether this remote type is a system built-in type
or a distinct type.
|
REMOTE_LOWER_LEN | INTEGER | Y | Minimum length or precision of the remote data type in this mapping, or the null value. For character types, represents the minimum number of characters (not bytes). For binary types, represents the minimum number of bytes. A value of -1 indicates that the default length or precision is used, or that the remote type does not have a length or precision. |
REMOTE_UPPER_LEN | INTEGER | Y | Maximum length or precision of the remote data type in this mapping, or the null value. For character types, represents the maximum number of characters (not bytes). For binary types, represents the maximum number of bytes. A value of -1 indicates that the default length or precision is used, or that the remote type does not have a length or precision. |
REMOTE_LOWER_SCALE | SMALLINT | Y | Minimum number of digits in the fractional part of a remote decimal value or the minimum number of digits of fractional seconds of a remote TIMESTAMP value in this mapping, or the null value. |
REMOTE_UPPER_SCALE | SMALLINT | Y | Maximum number of digits in the fractional part of a remote decimal value or the maximum number of digits of fractional seconds of a remote TIMESTAMP value in this mapping, or the null value. |
REMOTE_S_OPR_P | CHAR (2) | Y | Relationship between the scale and precision of a remote decimal value in this mapping. Basic comparison operators (=, <, >, <=, >=, <>) can be used. A null value indicates that no specific relationship is required. |
REMOTE_BIT_DATA | CHAR (1) | Y | Indicates whether or not this remote character type is for
bit data. Possible values are:
|
USER_DEFINED | CHAR (1) | Indicates whether or not the mapping is user-defined. The value is always 'Y'; that is, the mapping is always user-defined. | |
CREATE_TIME | TIMESTAMP | Time at which this mapping was created. | |
DEFINER1 | VARCHAR (128) | Authorization ID of the owner of the type mapping. 'SYSIBM' indicates a built-in type mapping. | |
REMARKS | VARCHAR (254) | Y | User-provided comments, or the null value. |
Note:
|