I noticed that. I am downloading a test version of DB2 and am going to install it then tweak the scripts to make them work.
Thanks, Bruce Sorge ----- Original Message ---- From: Jochem van Dieten <[EMAIL PROTECTED]> To: SQL <[email protected]> Sent: Thursday, April 26, 2007 2:10:12 PM Subject: Re: SQL Script Question 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 ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| ColdFusion MX7 by Adobe® Dyncamically transform webcontent into Adobe PDF with new ColdFusion MX7. Free Trial. http://www.adobe.com/products/coldfusion?sdid=RVJV Archive: http://www.houseoffusion.com/groups/SQL/message.cfm/messageid:2825 Subscription: http://www.houseoffusion.com/groups/SQL/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.6
