Hi All
(UDB 8.1 FP8, Win)
In my simple test database, I have two tables
CREATE TABLE "DB2ADMIN"."AAA" (
"F1" INTEGER NOT NULL GENERATED ALWAYS AS IDENTITY,
"F2" VARCHAR(10),
PRIMARY KEY ("F1")
)
and
CREATE TABLE "DB2ADMIN"."BBB" (
"F1" INTEGER NOT NULL GENERATED ALWAYS AS IDENTITY,
"F2" INTEGER NOT NULL,
PRIMARY KEY ("F1"),
CONSTRAINT fk_BBB FOREIGN KEY ("F2") REFERENCES DB2ADMIN.BBB("F1")
)
I try export this hierarchy (logged as DB2ADMIN)
EXPORT TO alldata.ixf OF IXF HIERARCHY STARTING BBB
and I get error message:
SQL0204N ""DB2ADMIN"."BBB".BBB" is an undefined name. SQLSTATE=42704
I try use .....STARTING DB2ADMIN.BBB
"DB2ADMIN"."BBB"
always the same
I can call EXPORT TO bbb.ixf OF IXF select * from BBB without any problems.
Anyone could help me find what is wrong?
Thanks
Yaro
Knut Stolze - 24 Feb 2005 07:08 GMT
> Hi All
>
[quoted text clipped - 20 lines]
> and I get error message:
> SQL0204N ""DB2ADMIN"."BBB".BBB" is an undefined name. SQLSTATE=42704
AAA and BBB are not a table hierarchy because they were not created as type
tables based on a type hierarchy. Thus, you can't use the HIERARCHY
keyword in the EXPORT statement.

Signature
Knut Stolze
Information Integration
IBM Germany / University of Jena
Yaro - 24 Feb 2005 09:24 GMT
Thank you
Y.
>> Hi All
>>
[quoted text clipped - 25 lines]
> tables based on a type hierarchy. Thus, you can't use the HIERARCHY
> keyword in the EXPORT statement.