Each row contains a user-defined mapping of a remote built-in data type to a local built-in data type.
|
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 characters. |
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 characters. |
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 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. |
No comments:
Post a Comment