Subject | Create OR Alter |
---|---|
Author | Uwe Oeder |
Post date | 2004-03-17T13:15:04Z |
Why does this fail I thought CREATE OR ALTER is now allowed ?
CREATE OR ALTER TABLE City
(
CityIDSQ INTEGER NOT NULL ,
CountryVBSQ INTEGER NOT NULL ,
CityName VARCHAR(30) NOT NULL ,
CityDiallingCode VARCHAR(10) NOT NULL ,
CityXPosition INTEGER ,
CityYPosition INTEGER ,
PRIMARY KEY (CityIDSQ) ,
FOREIGN KEY (CountryVBSQ) REFERENCES Country(CountryIDSQ) ,
UNIQUE (CityName , CountryVBSQ)
) ;
Statement failed, SQLCODE = -104
Dynamic SQL Error
-SQL error code = -104
-Token unknown - line 1, char 17
-TABLE
CREATE OR ALTER TABLE City
(
CityIDSQ INTEGER NOT NULL ,
CountryVBSQ INTEGER NOT NULL ,
CityName VARCHAR(30) NOT NULL ,
CityDiallingCode VARCHAR(10) NOT NULL ,
CityXPosition INTEGER ,
CityYPosition INTEGER ,
PRIMARY KEY (CityIDSQ) ,
FOREIGN KEY (CountryVBSQ) REFERENCES Country(CountryIDSQ) ,
UNIQUE (CityName , CountryVBSQ)
) ;
Statement failed, SQLCODE = -104
Dynamic SQL Error
-SQL error code = -104
-Token unknown - line 1, char 17
-TABLE