User Datatypes Wizard (DB2 Z/OS)

From DBArtisan
Jump to: navigation, search

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:

  1. Open a creation wizard for a user datatype. For details, see Opening an Object Wizard.
  2. Use the following topics as a guide to setting properties and performing tasks as you pass through the wizard panels:
  3. 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


Select the owner of the user datatype.


Provide a name for the datatype.


Select the base datatype.


Provide the size of the datatype.

For Data

Select the MIXED, SBCS, or BIT option for the datatype.


Select the NONE, ASCII, EBCDIC, or UNICODE option for the datatype.