User Datatypes
Go Up to Supported Objects
User-defined datatypes promote domain consistency by streamlining the definition of commonly used table columns in a database. You can build a customized datatype from system datatypes and bind defaults and rules to it to enhance integrity. When you reference the user datatype in a column, the column assumes all of the properties of the user datatype.
Creating and editing
- User Datatypes (DB2 LUW) and User Datatypes Editor (IBM DB2 LUW)
- User Datatypes Wizard (DB2 Z/OS) and User Datatypes Editor (IBM DB2 Z/OS)
- User Datatypes Wizard (SQL Server) and User Datatypes Editor (SQL Server)
- User Datatypes Wizard (Sybase ASE) and User Datatypes Editor (Sybase ASE)
DBMS platform availability and object actions/operations supported
The following table lists object actions available for this object type. For an introduction to object actions and details on usage of specific actions, see Object actions.
| DB2 LUW | DB2 z/OS | SQL SVR | SYB ASE | |
|---|---|---|---|---|
|
✓ |
✓ |
✓ |
✓ | |
|
✓ |
✓ |
✓ |
✓ | |
|
✓ |
✓ |
✓ |
✓ | |
|
✓ |
✓ | |||
|
✓ |
✓ |
✓ |
✓ | |
|
✓ |