locked
Db2 Script RRS feed

  • Question

  • USE [SBM_PROD]
    GO
    /****** Object:  Table [dbo].[CHANNEL]    Script Date: 03/09/2011 14:38:23 ******/
    SET ANSI_NULLS ON
    GO
    SET QUOTED_IDENTIFIER ON
    GO
    CREATE TABLE [dbo].[CHANNEL](
     [CHN_CHANNELID] [dbo].[T_TRE_ID] NOT NULL,
     [CHN_CHANNELNAME] [dbo].[T_TRE_NAME] NOT NULL,
     [CHN_CREAUSER] [dbo].[T_TRE_USERID] NULL,
     [CHN_CREADATETIME] [dbo].[T_TRE_DATETIME] NULL,
     [CHN_MODIFIEDBY] [dbo].[T_TRE_USERID] NULL,
     [CHN_MODIDATETIME] [dbo].[T_TRE_DATETIME] NULL,
     CONSTRAINT [PK_CHANNEL] PRIMARY KEY CLUSTERED
    (
     [CHN_CHANNELID] ASC
    )WITH (PAD_INDEX  = OFF, STATISTICS_NORECOMPUTE  = OFF, IGNORE_DUP_KEY = OFF, ALLOW_ROW_LOCKS  = ON, ALLOW_PAGE_LOCKS  = ON, FILLFACTOR = 100) ON [PRIMARY]
    ) ON [PRIMARY]

     

    this is sqlserver script plz convert this script to db2 script

    Wednesday, March 9, 2011 9:15 AM