Problem with EXPORT HIERARCHY

[Yaro]

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("F 1")
)

I try export this hierarchy (logged as DB2ADMIN)
EXPORT TO alldata.ixf OF IXF HIERARCHY STARTING BBB
and I get error message:
SQL0204N ""DB2ADMIN"."BB B".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]

Yaro wrote:

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("F 1")
)

I try export this hierarchy (logged as DB2ADMIN)
EXPORT TO alldata.ixf OF IXF HIERARCHY STARTING BBB
and I get error message:
SQL0204N ""DB2ADMIN"."BB B".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.

--
Knut Stolze
Information Integration
IBM Germany / University of Jena

[Yaro]

Thank you

Y.
Uzytkownik "Knut Stolze" <st****@de.ibm. com> napisal w wiadomosci
news:cv******** **@fsuj29.rz.un i-jena.de...

Yaro wrote:

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("F 1")
)

I try export this hierarchy (logged as DB2ADMIN)
EXPORT TO alldata.ixf OF IXF HIERARCHY STARTING BBB
and I get error message:
SQL0204N ""DB2ADMIN"."BB B".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.

--
Knut Stolze
Information Integration
IBM Germany / University of Jena