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 ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| 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:2822 Subscription: http://www.houseoffusion.com/groups/SQL/subscribe.cfm Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.6
