User Datatypes (DB2 LUW)
Go Up to IBM DB2 for Linux, Unix, and Windows Object Wizards
User defined datatypes allow column definitions to be consistent across a database. They let you associate frequently used datatype information to be associated with a specified function and take advantage of performance features available to built-in datatypes including indexing and parallel database queries.
To create a new user datatype using a wizard:
- Open a creation wizard for a user datatype. For details, see Opening an Object Wizard.
- Use the following topics as a guide to setting properties and performing tasks as you pass through the wizard panels:
- Properties panel - for details, see User Datatypes (DB2 LUW) - Properties.
- Comment panel - for details, see Adding a Comment to an Object.
- DDL View panel - for details, see Previewing the DDL Generated to Create the New Object.
- Finally, use the Execute button to create the object.
User Datatypes (DB2 LUW) - Properties
When creating or editing a user datatype, this tab/panel lets you work with the following settings:
Setting | Description |
---|---|
Owner |
Select the owner of the user datatype. |
Datatype |
Provide a name for the datatype. |
Type |
Select the base datatype. |
Size |
Provide the size of the datatype. |
Allow Bit Data |
The option is only available for certain datatypes. A check means you want to store the data in a bit format. |