-- -- 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. -- ------------------------------------------------------------------------------- -- NC834_UPDATE_ORA.SQL *DO NOT EDIT* Data Store Version: 834 ------------------------------------------------------------------------------- ------------------------------------------------------------------------------- --$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 ------------------------------------------------------------------------------- ------------------------------------------------------------------------------- --$203-- alter tables begin ------------------------------------------------------------------------------- ------------------------------------------------------------------------------- --$210-- views create begin ------------------------------------------------------------------------------- ------------------------------------------------------------------------------- --$220-- server data inserts begin ------------------------------------------------------------------------------- INSERT INTO NC_DB_VERSION (DB_VERSION_ID,BUILD) VALUES(834,'build no.'); ------------------------------------------------------------------------------- --$230-- restore inserts begin ------------------------------------------------------------------------------- ------------------------------------------------------------------------------- --$250-- backup drop begin ------------------------------------------------------------------------------- ------------------------------------------------------------------------------- --$260-- end sql by function ------------------------------------------------------------------------------- -- END NC834_UPDATE_ORA.SQL * DO NOT EDIT * -------------------------------------------------------------------------------