| 12345678910111213141516171819202122232425262728293031 |
- -- Licensed Materials - Property of IBM
- -- IBM Cognos Products: ccllogging
- -- (C) Copyright IBM Corp. 2005, 2010
- -- US Government Users Restricted Rights - Use, duplication or disclosure restricted by GSA ADP Schedule Contract with IBM Corp.
- rename COGIPF_ACTION to COGIPF_ACTION_OLD
- create table COGIPF_ACTION (
- COGIPF_HOST_IPADDR varchar (15),
- COGIPF_HOST_PORT integer,
- COGIPF_PROC_ID integer,
- COGIPF_LOCALTIMESTAMP timestamp,
- COGIPF_TIMEZONE_OFFSET integer,
- COGIPF_SESSIONID varchar (255),
- COGIPF_REQUESTID varchar (255) not null,
- COGIPF_STEPID varchar (255),
- COGIPF_SUBREQUESTID varchar (255),
- COGIPF_THREADID varchar (255),
- COGIPF_COMPONENTID varchar (64),
- COGIPF_BUILDNUMBER integer,
- COGIPF_LOG_LEVEL integer,
- COGIPF_OPERATION varchar (255),
- COGIPF_TARGET_TYPE varchar (255),
- COGIPF_TARGET_PATH varchar (1024),
- COGIPF_STATUS varchar (255),
- COGIPF_ERRORDETAILS varchar (2000)
- )
- insert into COGIPF_ACTION select * from COGIPF_ACTION_OLD
- drop table COGIPF_ACTION_OLD
|
