Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
Discussion Groups
Database Servers
DB2InformixIngresMS SQLOraclePervasive.SQLPostgreSQLProgressSybase
Desktop Databases
FileMakerFoxProMS AccessParadox
General
General DB TopicsDatabase Theory
Related Topics
Java Development.NET DevelopmentVB DevelopmentMore Topics ...

Database Forum / DB2 Topics / February 2005

Tip: Looking for answers? Try searching our database.

Problem with EXPORT HIERARCHY

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
Yaro - 23 Feb 2005 13:11 GMT
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.
 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2009 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.