DB2 to Oracle Migrations (Object Type)

jumshoos · #1 (**permalink**) 09-01-11, 09:56

Hi,

Can anyone please help me to convert object types from Oracle into DB2 .

for example :

CREATE TYPE address_type AS OBJECT
(ADDR_LINE VARCHAR2(50),
CITY VARCHAR2(50),
STATE VARCHAR2(02),
ZIP VARCHAR2(05));
/
CREATE TYPE address_table_type AS TABLE OF address_type;
/

CREATE TABLE employee (
Name VARCHAR2(20),
addresses ADDRESS_TABLE_TYPE)
NESTED TABLE addresses STORE AS addresses_table;

n_i · #2 (**permalink**) 09-01-11, 10:00

Code:

CREATE TYPE address_type is RECORD
       (ADDR_LINE        VARCHAR2(50),
        CITY             VARCHAR2(50),
        STATE            VARCHAR2(02),
        ZIP              VARCHAR2(05));
/
CREATE TYPE address_table_type AS TABLE OF address_type
index by binary_integer;
/

Nested tables are not supported.