Hello,

I want to import data into my database (V8.1) and before I created the tables like this:

CREATE TABLE "MUSIK" OF "MUSIK_TYPE"
UNDER "MEDIUM" INHERIT SELECT PRIVILEGES

CREATE TYPE "MUSIK_TYPE" UNDER "MEDIUM_TYPE" AS
("GENRE" VARCHAR(15),
"EINHEIT" VARCHAR(10))
INSTANTIABLE
INLINE LENGTH 467
WITHOUT COMPARISONS
NOT FINAL
MODE DB2SQL

CREATE TYPE "MEDIUM_TYPE" AS
("NAME" VARCHAR(30),
"URL" DATALINK LINKTYPE URL NO LINK CONTROL,
"PREIS" PREIS_TYPE,
"BILD" BLOB(500K) NOT LOGGED)
INSTANTIABLE
INLINE LENGTH 418
WITHOUT COMPARISONS
NOT FINAL
REF USING INTEGER
MODE DB2SQL

What is the correct i m p o r t instruction, because of MEDIUM_TYPE and PREIS_TYPE ?

Perhaps something like this:
"import from musik.del of DEL insert into musik(oid, name, url, preis_type(wert, waehrung), genre, einheit)" ???

Thanks in advance

S.C.