Creation and usage of user defined data types

Shefu · #1 (**permalink**) 12-29-05, 09:34

hi,

Is it possible to create a user defined data type in DB2

1. if yes, is there any limitations in the usage of user defined data types. like it could be used only in tables or so and so..

thanks,
Sn

Peter.Vanroose · #2 (**permalink**) 01-06-06, 05:51

Examples:

Code:

CREATE DISTINCT TYPE SHOESIZE AS INTEGER WITH COMPARISONS
CREATE DISTINCT TYPE AUDIO AS BLOB(1M)
CREATE TYPE DEPT AS (DEPT NAME VARCHAR(20), MAX_EMPS INT) MODE DB2SQL

See http://publib.boulder.ibm.com/infoce...n/r0000913.htm and http://publib.boulder.ibm.com/infoce...n/r0000933.htm

No severe limitations in using these types, provided you specify all the necessary attributes (like comparisons, or conversions to basic types)

Internet Services

Web Development

Digital Marketing

Consumer Tech