Enterprise Edition Home |
Express Edition Home |
Previous Page | Next Page SQL Statements > SET DESCRIPTOR >
The following item-descriptor fields provide information
about a column that has an opaque type as its data type:
- The EXTYPEID field stores the extended identifier
for the opaque type. This integer value must correspond to a value in the extended_id column of the sysxtdtypes system
catalog table.
- TheEXTYPENAME field stores the name of the
opaque type. This character value must correspond to a value in the name column of the row with the matching extended_id value in the sysxtdtypes system catalog table.
- The EXTYPELENGTH field stores the length of the
opaque-type name. This integer value is the length, in bytes, of the string
in the EXTYPENAME field.
- The EXTYPEOWNERNAME field stores the name of the opaque-type
owner. This character value must correspond to a value in the owner column of the row with the matching extended_id value in the sysxtdtypes system catalog table.
- The EXTYPEOWNERLENGTH field stores the length of
the value in the EXTTYPEOWNERNAME field. This integer
value is the length, in bytes, of the string in the EXTYPEOWNERNAME field.
For more information on the sysxtdtypes system catalog
table, see the IBM Informix Guide to SQL: Reference.
Enterprise Edition Home |
Express Edition Home |
[ Top of Page | Previous Page | Next Page | Contents |
Index ]