TYPE

Types define a synonym for a base or structured data type.

Syntax:

[PUBLIC|PRIVATE] TYPE type-definition [,...]

where type-definition is:

identifier { datatype | LIKE [dbname:]tabname.colname }
  1. identifier is the name of the type to be defined.
  2. datatype is any data type, record structure, or array definition supported by the language.
  3. The LIKE syntax references a table column in the current database schema.