Oracle 'Type' in DB2?

Shefu · #1 (**permalink**) 05-17-06, 04:03

Hi all,

We have an object 'TYPE' in Oracle that can be declared and defined in the Oracle database and can be used in the Database programs.

Is there anything similar to that in DB2.

with thanks n regards.
Sn

Marcus_A · #2 (**permalink**) 05-17-06, 11:54

Did you check out CREATE TYPE in the DB2 SQL Reference Vol 2?

Shefu · #3 (**permalink**) 05-25-06, 02:05

I do checked the CREATE TYPE in the DB2 SQL Reference Vol 2, but its some thing like structured datatype. What i am looking for is like OBJECT

ie.. the Oracle TYPE can have data and member functions to access the data with in them. can anyone help me in identifying the same in DB2.

thanks in advance,
Sn

Internet Services

Web Development

Digital Marketing

Consumer Tech