Well if the if exists part is going to be an issue, I can get rid of it since the tables do not exist. Is that the part that I need to get rid of to make it standard SQL?
Thanks, Bruce On 4/26/07, Jochem van Dieten <[EMAIL PROTECTED]> wrote: > > Bruce Sorge wrote: > > > > if exists (select * from dbo.sysobjects where id = > > object_id(N'[dbo].[Titles]') and OBJECTPROPERTY(id, N'IsUserTable') = 1) > > drop table [dbo].[Titles] > > GO > > > > CREATE TABLE [dbo].[Titles] ( > > [Title_ID] [int] IDENTITY (1, 1) NOT NULL , > > [Title] [varchar] (100) COLLATE SQL_Latin1_General_CP1_CI_AS NULL > > ) ON [PRIMARY] > > GO > > > > Will this work on a DB2 server or do I need to make any changes? > > You will need to make changes. Your best bet is to first reduce this to > standard SQL and then try to run it on DB2 and fix it as you go. > > Jochem > > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Upgrade to Adobe ColdFusion MX7 The most significant release in over 10 years. Upgrade & see new features. http://www.adobe.com/products/coldfusion?sdid=RVJR Archive: http://www.houseoffusion.com/groups/SQL/message.cfm/messageid:2823 Subscription: http://www.houseoffusion.com/groups/SQL/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=89.70.6
