CREATE OPAQUE TYPE

>>-CREATE OPAQUE TYPE--type------------------------------------->
 
>--(--INTERNALLENGTH-- =--+-length---+--+--------------------------------------+--)-><
                          '-VARIABLE-'  |    .-,-----------------------------. |
                                        |    V                          (1)  | |
                                        '-,----| Opaque-Type Modifier |------+-'

Notes:

See Opaque-Type Modifier

Element	Description	Restrictions	Syntax
length	Number of bytes needed to store a value of this data type	Positive integer returned when sizeof( ) directive is applied to the type structure	Literal Number
type	Name that you declare here for the new opaque data type	Must be unique among data type names in the database	Identifier; Data Type

The CREATE OPAQUE TYPE statement registers a new opaque data type in the sysxtdtypes system catalog table.

To create an opaque type, you must have the Resource privilege on the database. When you create the opaque type, only you, the owner, have the Usage privilege on the new opaque data type. You can use the GRANT or REVOKE statements to grant or revoke the Usage privilege of other users of the database.

To view the privileges on a data type, check the sysxtdtypes system catalog table for the owner name, and check the sysxtdtypeauth system catalog table for additional type privileges that might have been granted.

For details of system catalog tables, see the IBM Informix Guide to SQL: Reference.

The DB–Access utility can also display privileges on opaque data types.

CREATE OPAQUE TYPE

Syntax

Usage