-- -- Licensed Materials - Property of IBM -- -- BI and PM: ANS -- -- (c) Copyright IBM Corp. 2016. -- -- US Government Users Restricted RigANS - Use, duplication or disclosure restricted by GSA ADP Schedule Contract with IBM Corp. -- ------------------------------------------------------------------------------- -- ANS3_UPDATE_Db2Zos.SQL *DO NOT EDIT* Data Store Version: 3 ------------------------------------------------------------------------------- ------------------------------------------------------------------------------- --$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 ------------------------------------------------------------------------------- ALTER TABLE ANN_CONTEXT ALTER COLUMN compID SET DATA TYPE VARCHAR(512); ------------------------------------------------------------------------------- --$210-- views create begin ------------------------------------------------------------------------------- ------------------------------------------------------------------------------- --$220-- server data inserts begin ------------------------------------------------------------------------------- ------------------------------------------------------------------------------- --$230-- restore inserts begin ------------------------------------------------------------------------------- ------------------------------------------------------------------------------- --$250-- backup drop begin ------------------------------------------------------------------------------- ------------------------------------------------------------------------------- --$260-- end sql by function ------------------------------------------------------------------------------- -- END ANS3_UPDATE_Db2Zos.SQL * DO NOT EDIT * -------------------------------------------------------------------------------