| 123456789101112131415161718192021222324252627 |
- -- Licensed Materials - Property of IBM
- -- IBM Cognos Products: ccllogging
- -- (C) Copyright IBM Corp. 2013
- -- US Government Users Restricted Rights - Use, duplication or disclosure restricted by GSA ADP Schedule Contract with IBM Corp.
- sp_rename 'COGIPF_PARAMETER', 'COGIPF_PARAMETER_OLD'
- CREATE TABLE COGIPF_PARAMETER (
- COGIPF_LOCALTIMESTAMP datetime NULL ,
- COGIPF_SESSIONID varchar (255) NULL ,
- COGIPF_REQUESTID nvarchar (255) NOT NULL ,
- COGIPF_SUBREQUESTID nvarchar (255) NULL ,
- COGIPF_STEPID nvarchar (255) NULL ,
- COGIPF_OPERATION varchar (255) NULL ,
- COGIPF_TARGET_TYPE varchar (255) NULL ,
- COGIPF_PARAMETER_NAME varchar (255) NULL ,
- COGIPF_PARAMETER_VALUE nvarchar (512) NULL ,
- COGIPF_PARAMETER_VALUE_BLOB ntext NULL
- )
- insert into COGIPF_PARAMETER (COGIPF_REQUESTID,COGIPF_STEPID,COGIPF_OPERATION,COGIPF_TARGET_TYPE,COGIPF_PARAMETER_NAME,COGIPF_PARAMETER_VALUE) select * from COGIPF_PARAMETER_OLD
- drop table COGIPF_PARAMETER_OLD
|
