SQL Reference

SYSCAT.TYPEMAPPINGS

Each row contains a user-defined mapping of a remote built-in data type to a local built-in data type.

Table 93. SYSCAT.TYPEMAPPINGS Catalog View

Column Name Data Type Nullable Description
TYPE_MAPPING VARCHAR(18)
Name of the 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 data type mapping.
TYPEID SMALLINT
Type identifier.
SOURCETYPEID SMALLINT
Source type identifier.
DEFINER VARCHAR(128)
Authorization ID under which this type mapping was created.
LENGTH INTEGER Yes Maximum length or precision of the data type. If null, the system determines the best length/precision.
SCALE SMALLINT Yes Scale for DECIMAL fields. If null, the system determines the best scale attribute.
BIT_DATA CHAR(1) Yes

Y = Type is for bit data.
N = Type is not for bit data.
NULL = This is not a character data type or that the system determines the bit data attribute.

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

S = Remote type is a system built-in type.
T = Remote type is a distinct type.

REMOTE_LOWER_LEN INTEGER Yes Lower bound of the length/precision of the remote decimal type. For character data types, this field indicates the number of character.
REMOTE_UPPER_LEN INTEGER Yes Upper bound of the length/precision of the remote decimal type. For character data types, this field indicates the number of character.
REMOTE_LOWER_SCALE SMALLINT Yes Lower bound of the scale of the remote type.
REMOTE_UPPER_SCALE SMALLINT Yes Upper bound of the scale of the remote type.
REMOTE_S_OPR_P CHAR(2) Yes Relationship between remote scale and remote precision. Basic comparison operators can be used. A null indicated that no specific relationship is required.
REMOTE_BIT_DATA CHAR(1) Yes

Y = Type is for bit data.
N = Type is not for bit data.
NULL = This is not a character data type or that the system determines the bit data attribute.

USER_DEFINED CHAR(1)
Definition supplied by user.
CREATE_TIME TIMESTAMP
Time when this mapping was created.
REMARKS VARCHAR(254) Yes User supplied comments, or null.

Column Name	Data Type	Nullable	Description
TYPE_MAPPING	VARCHAR(18)		Name of the 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 data type mapping.
TYPEID	SMALLINT		Type identifier.
SOURCETYPEID	SMALLINT		Source type identifier.
DEFINER	VARCHAR(128)		Authorization ID under which this type mapping was created.
LENGTH	INTEGER	Yes	Maximum length or precision of the data type. If null, the system determines the best length/precision.
SCALE	SMALLINT	Yes	Scale for DECIMAL fields. If null, the system determines the best scale attribute.
BIT_DATA	CHAR(1)	Yes	Y = Type is for bit data. N = Type is not for bit data. NULL = This is not a character data type or that the system determines the bit data attribute.
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	S = Remote type is a system built-in type. T = Remote type is a distinct type.
REMOTE_LOWER_LEN	INTEGER	Yes	Lower bound of the length/precision of the remote decimal type. For character data types, this field indicates the number of character.
REMOTE_UPPER_LEN	INTEGER	Yes	Upper bound of the length/precision of the remote decimal type. For character data types, this field indicates the number of character.
REMOTE_LOWER_SCALE	SMALLINT	Yes	Lower bound of the scale of the remote type.
REMOTE_UPPER_SCALE	SMALLINT	Yes	Upper bound of the scale of the remote type.
REMOTE_S_OPR_P	CHAR(2)	Yes	Relationship between remote scale and remote precision. Basic comparison operators can be used. A null indicated that no specific relationship is required.
REMOTE_BIT_DATA	CHAR(1)	Yes	Y = Type is for bit data. N = Type is not for bit data. NULL = This is not a character data type or that the system determines the bit data attribute.
USER_DEFINED	CHAR(1)		Definition supplied by user.
CREATE_TIME	TIMESTAMP		Time when this mapping was created.
REMARKS	VARCHAR(254)	Yes	User supplied comments, or null.

[ Top of Page | Previous Page | Next Page | Table of Contents | Index ]

[ DB2 List of Books | Search the DB2 Books ]