Create a distinct type
Creating a new distinct type based on an existing data type can give you greater control over your data. To view the SQL
used to create this object, click Show SQL.
To create a distinct type:
- In the System i Navigator window, expand the system you want to use.
- Expand Databases.
- Expand the database and schema that you want to work with.
- Right-click the Distinct types container and select New, then Distinct type.
- On the New Distinct Type dialog, specify the name that you want to give the new type in the Name field.
- Specify the schema where the type will reside in the Type schema field.
- Specify the data type on which the new type is based in the Data type field. Specify any other information that is required
for the data type.
- In the Text field, specify a description of the new alias. This description
can be up to 50 characters long. This field is optional.
- Click OK.