User Datatypes Wizard (DB2 Z/OS)
Go Up to IBM DB2 for z/OS Object Wizards
A datatype is a named set of valid values that can be manipulated by a set of operations. There are intrinsic datatypes, which are predefined and always available, and derived datatypes. A derived datatype is a user-defined datatype, which can include both intrinsic and previously derived datatypes. The User Datatype Wizard lets you create a derived datatype without knowing the underlying commands.
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 z/OS) - 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 z/OS) - 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. |
For Data |
Select the MIXED, SBCS, or BIT option for the datatype. |
CCSID |
Select the NONE, ASCII, EBCDIC, or UNICODE option for the datatype. |