-- -- 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. -- ------------------------------------------------------------------------------- -- NC831_UPDATE_IFX.SQL * DO NOT EDIT * Data Store Version: 831 ------------------------------------------------------------------------------- ------------------------------------------------------------------------------- --$130-- views drop begin ------------------------------------------------------------------------------- ------------------------------------------------------------------------------- --$120-- foreign keys drop begin ------------------------------------------------------------------------------- ------------------------------------------------------------------------------- --$135-- build/rebuild/populate tables ------------------------------------------------------------------------------- -------------------------------NC_DB_VERSION----------------------------------- INSERT INTO NC_DB_VERSION (DB_VERSION_ID,BUILD) VALUES(831,'build no.'); --$200-- table create begin ------------------------------------------------------------------------------- --$210-- views create begin ------------------------------------------------------------------------------- ------------------------------------------------------------------------------- --$230-- restore inserts begin ------------------------------------------------------------------------------- ------------------------------------------------------------------------------- --$240-- foreign keys add begin ------------------------------------------------------------------------------- ------------------------------------------------------------------------------- --$260-- end sql by function ------------------------------------------------------------------------------- -- END NC831_UPDATE_IFX.SQL * DO NOT EDIT * -------------------------------------------------------------------------------