SQL Reference

SYSCAT.REVTYPEMAPPINGS

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

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

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)
Defined 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 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	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_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	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)		Defined 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 ]