I have an application that is going live on the 5th. The development DB
server is SQL 2000, but the live server is DB2 (there was no available DB2
server to develop on). I am creating the scrips to prepare for the new app
(create tables, alter existing tables, insert and copy data), but I am
wondering if this will work on the DB2 server. I do not have any experience
on DB2 which is why I am asking. So for instance, I have this script:
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?
Thanks,
--
Bruce Sorge
"I'm a mawg: half man, half dog. I'm my own best friend!"
~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~|
ColdFusion MX7 and Flex 2
Build sales & marketing dashboard RIAâs for your business. Upgrade now
http://www.adobe.com/products/coldfusion/flex2?sdid=RVJT
Archive: http://www.houseoffusion.com/groups/SQL/message.cfm/messageid:2821
Subscription: http://www.houseoffusion.com/groups/SQL/subscribe.cfm
Unsubscribe:
http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.6
