-- -- 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. -- ------------------------------------------------------------------------------- -- NC14_UPDATE_DB2.SQL *DO NOT EDIT* Data Store Version: 14 ------------------------------------------------------------------------------- ------------------------------------------------------------------------------- --$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(14,'build no.'); UPDATE NC_CONFIGURATION SET PROPERTY_VALUE = 'com.cognos.js2.PersistedJobQueueFactory' WHERE PROPERTY_KEY = 'job.queue.factory.class'; ------------------------------------------------------------------------------- --$230-- restore inserts begin ------------------------------------------------------------------------------- ------------------------------------------------------------------------------- --$250-- backup drop begin ------------------------------------------------------------------------------- ------------------------------------------------------------------------------- --$260-- end sql by function ------------------------------------------------------------------------------- -- END NC14_UPDATE_DB2.SQL * DO NOT EDIT * -------------------------------------------------------------------------------