Bruce Sorge wrote:
> Well if the if exists part is going to be an issue, I can get rid of it
> since the tables do not exist.
That will significantly reduce the work.
> Is that the part that I need to get rid of to
> make it standard SQL?
You need more changes. For DB2 you need something like:
CREATE TABLE Titles (
Title_ID INT NOT NULL GENERATED ALWAYS AS IDENTITY,
Title varchar(100) NULL,
PRIMARY KEY (Title_ID)
);
Jochem
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
Create robust enterprise, web RIAs.
Upgrade & integrate Adobe Coldfusion MX7 with Flex 2
http://www.adobe.com/products/coldfusion/flex2/?sdid=RVJP
Archive: http://www.houseoffusion.com/groups/SQL/message.cfm/messageid:2824
Subscription: http://www.houseoffusion.com/groups/SQL/subscribe.cfm
Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.6
