User Datatypes Editor (IBM DB2 LUW)

From DBArtisan
Jump to: navigation, search

Go Up to IBM DB2 for Linux, Unix, and Windows Object Editors

The User Datatypes Editor lets you manage the basic properties of a user datatype.

To edit a user datatype

  1. Open an editor on the user datatype. For details, see Opening an Object Editor.
  2. Use the following table as a guide to understanding and modifying the settings on the tabs of this editor:
Tab Settings and tasks


Displays the user Datatype name. Lets you select a new Owner or Type, and depending on the type specified, offers additional type-specific properties such as Size. Also lets you modify the Allow Bit Data property, if appropriate.


For details on using this tab, see Adding a Comment to an object.

DDL View

For details on using this tab, see Viewing the SQL/DDL for an Object.

3. When finished, you can submit your changes. For details, see Previewing and Submitting Object Editor Changes.