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.
Table 1. SYSCAT.TYPEMAPPINGS Catalog View
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.
  • F = Forward type mapping
  • R = 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)  
  • S = The owner is the system
  • U = The owner is an individual user
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:
  • N = This type is not for bit data
  • Y = This type is for bit data
  • Null value = This is not a character data type, or the system determines the bit data attribute
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.
  • S = System built-in type
  • T = 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:
  • N = This type is not for bit data
  • Y = This type is for bit data
  • Null value = This is not a character data type, or the system determines the bit data attribute
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:
  1. The DEFINER column is included for backwards compatibility. See OWNER.