|
|
|
|
|
|
| Author |
Message |
Yaro
*nix forums beginner
Joined: 02 Feb 2005
Posts: 30
|
 Posted: Thu Feb 24, 2005 8:24 am Post subject:
Re: Problem with EXPORT HIERARCHY
|
|
|
Thank you
Y.
Uzytkownik "Knut Stolze" <stolze@de.ibm.com> napisal w wiadomosci
news:cvjuko$emf$1@fsuj29.rz.uni-jena.de...
| Quote: | 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("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
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 |
|
|
| Back to top |
|
 |
Knut Stolze
*nix forums Guru
Joined: 28 Jul 2005
Posts: 755
|
| Posted: Thu Feb 24, 2005 6:10 am Post subject:
Re: Problem with EXPORT HIERARCHY
|
|
|
Yaro wrote:
| Quote: | 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
|
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 |
|
| Back to top |
|
|
Yaro
*nix forums beginner
Joined: 02 Feb 2005
Posts: 30
|
| Posted: Wed Feb 23, 2005 12:11 pm Post subject:
Problem with EXPORT HIERARCHY
|
|
|
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 |
|
| Back to top |
|
|
Google
|
|
| Back to top |
|
|
|
|
The time now is Thu Jan 08, 2009 2:40 am | All times are GMT
|
|
Online Name | Bankruptcy | Unsecured Credit Cards | Secured Loans | Loan
|
|
Copyright © 2004-2005 DeniX Solutions SRL
|
|
|
|
Other DeniX Solutions sites:
Unix/Linux blog |
electronics forum |
medicine forum |
science forum |
|
|
Privacy Policy
|
Powered by phpBB © 2001, 2005 phpBB Group
|
|
FAQ
Search
Memberlist
Usergroups
Register
Profile
Log in to check your private messages
Log in
Forum index
»
Databases
»
IBM DB2
