Figure 5 : Fichiers script T-SQL (.sch) qui capturent les schémas d'articles
SET QUOTED_IDENTIFIER ON GO DELETE FROM [ADDRESS] GO SET ANSI_PADDING ON GO IF NOT EXISTS (SELECT * FROM sysobjects WHERE id = object_id(N'[ADDRESS]') AND OBJECTPROPERTY(id, N'IsUserTable') = 1) BEGIN CREATE TABLE [ADDRESS] ( [ADDRESS_ID] [float] NOT NULL ,
[ADDRESS_NUMBER] [float] NULL ,
[LEADING_ZERO] [varchar] (1) NULL ,
[ADDRESS_NUMBER_CHAR] [varchar] (7) NULL ,
[STREET_ID] [float] NOT NULL ,
[UNIT_TYPE_ABBREV] [varchar] (4) NULL ,
[UNIT_VALUE] [varchar] (7) NULL ,
[ZIP_CODE] [varchar] (5) NULL ,
[ZIP4] [varchar] (4) NULL ,
[JURISDICTION_ID] [float] NOT NULL
)
END
GO
Figure 6 : Fichiers script T-SQL (.idx) qui capturent les index d’articles
CREATE UNIQUE CLUSTERED INDEX [PK_ADDRESS] ON [address]([ADDRESS_
ID])
GO
CREATE INDEX [street_idx] ON [address]([STREET_NAME_ID])
GO
CREATE INDEX [addressno_idx] ON [address]([ADDRESS_NUMBER])
GO
CREATE INDEX [charaddr_idx] ON [address]([ADDRESS_NUMBER_CHAR])
GO
CREATE INDEX [zip_idx] ON [address]([ADDRESS_ZIP_CODE])
GO
Comment faire évoluer son patrimoine IBMi en le rendant Cloud compatible ? Comment capitaliser sur des bases saines pour un avenir serein ? Faites le point et partagez l'expertise Hardis Group et IBM aux côtés de Florence Devambez, DSI d'Albingia.
