> 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

There is no CREATE OR ALTER TABLE statement, but there is
the new CREATE OR ALTER PROCEDURE | TRIGGER.


Best Regards,
Thomas Steinmaurer
LogManager Serie - Logging/Auditing Suites supporting
InterBase, Firebird, Advantage Database and MS SQL Server
Upscene Productions
http://www.upscene.com