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


[ Top of Page | Previous Page | Next Page ]