Niels, I have no idea.

Here is the script it tries to execute:

CREATE DISTINCT TYPE "andy" AS VARCHAR(25)
    WITH COMPARISONS

Ivan, do you have any comments on this?

is this a problem of setting Schema ?

This bug is not isolated to db2 iseries.  looks like the UDDT dialog is not designed to handle qualifing the object name

this names are created not using schema + "." + name

MSTriggersNode

CREATE TRIGGER [ schema_name . ]trigger_name ON { table | view }

CREATE TYPE [ schema_name. ] type_name { FROM base_type

CREATE RULE [ schema_name . ] rule_name AS condition_expression

CREATE DEFAULT [ schema_name . ] default_name AS constant_expression [ ; ]

Andy, can you add an optional Schema Combo Box for this?  We will need to be able to select and choose a Schema for certain databases, not for others.  MS SQL Server 2000 and below, Sybase ASE, Sybase IQ and Sybase Anywhere will not have the combo box.

added schema combo box to DataTypeDialog - seems to work in DB2iSeries, as well as SQL Server 2008.  Please test elsewhere.

Notice DataTypeDialo.supportsSchema() method, whichshould be in that DatabaseType class...

-- Data type bound to schema

Derby:                 Yes
DB2 LUW:               Yes
DB2 iSeries:           Yes
DB2 z/OS:              Yes
Informix:              Yes
Oracle:                Yes
MySQL:                 No
MS SQL Server 7/2k:    No
MS SQL Server 25k/28k: Yes
Sybase ASE:            No
Sybase Any:            No
Sybase IQ:             No
PostgreSQL:            Yes
Teradata:              No
nCluster:              Yes

AFDataType.java, ScriptDataType.java ... DataTypeDialog.java

working for the most part, following areas have issues, fix in 8.0???

//informix: lets you add a distinct type from collection type node, thus not refreshing distinct type node after type added...
//ORACLE: Object Types node doesn't allow you to right click and visual edit...
//ORACLE: Array Types sorta works... the basics work but the visual editor seems to have issues...
//ORACLE: Table Types node, seems to be a copy of Array Type node visual editor...
// Postgres doesn't have a visual editor for data types
// Sybase Anywhere has no UDDT node
// Sybase IQ has no UDDT node
// nCluster has no UDDT node

UDDT for Iseries works in ADS build 7.9.68