| 123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263 |
- --
- -- Licensed Materials - Property of IBM
- --
- -- BI and PM: JSM
- --
- -- (c) Copyright IBM Corp. 2003, 2010.
- --
- -- US Government Users Restricted Rights - Use, duplication or disclosure restricted by GSA ADP Schedule Contract with IBM Corp.
- --
- -------------------------------------------------------------------------------
- -- NC16_UPDATE_MS.SQL *DO NOT EDIT* Data Store Version: 16
- -------------------------------------------------------------------------------
- ---- Ver 16 is a DB2 only upgrade, need empty script here for completeness ----
- -------------------------------------------------------------------------------
- --$100-- backup create begin
- -------------------------------------------------------------------------------
- -------------------------------------------------------------------------------
- --$110-- backup inserts begin
- -------------------------------------------------------------------------------
- -------------------------------------------------------------------------------
- --$130-- views drop begin
- -------------------------------------------------------------------------------
- -------------------------------------------------------------------------------
- --$140-- tables drop begin
- -------------------------------------------------------------------------------
- -------------------------------------------------------------------------------
- --$200-- recreate tables begin
- -------------------------------------------------------------------------------
- -------------------------------------------------------------------------------
- --$202-- primary keys add begin
- -------------------------------------------------------------------------------
- -------------------------------------------------------------------------------
- --$210-- views create begin
- -------------------------------------------------------------------------------
- -------------------------------------------------------------------------------
- --$220-- server data inserts begin
- -------------------------------------------------------------------------------
- INSERT INTO NC_DB_VERSION (DB_VERSION_ID,BUILD) VALUES(16,'build no.')
- go
- -------------------------------------------------------------------------------
- --$230-- restore inserts begin
- -------------------------------------------------------------------------------
- -------------------------------------------------------------------------------
- --$250-- backup drop begin
- -------------------------------------------------------------------------------
- -------------------------------------------------------------------------------
- --$260-- end sql by function
- -------------------------------------------------------------------------------
- -- END NC16_UPDATE_MS.SQL * DO NOT EDIT *
- -------------------------------------------------------------------------------
|
