User Datatypes (DB2 LUW)
Go Up to IBM DB2 for Linux, Unix, and Windows Object Wizards
User defined datatypes allow you to have column definitions that are consistent across a database. They let you associate frequently-used datatype information with a specified function and provide 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.
- Click Execute 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. |