| 1234567891011121314151617181920212223242526272829303132333435363738 |
- -- 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.
- CREATE TABLE COGIPF_MOBILESERVICE (
- COGIPF_HOST_IPADDR varchar (128) NULL ,
- COGIPF_HOST_PORT int NULL ,
- COGIPF_PROC_ID int NULL ,
- COGIPF_LOCALTIMESTAMP datetime NULL ,
- COGIPF_TIMEZONE_OFFSET int NULL ,
- COGIPF_SESSIONID varchar (255) NULL ,
- COGIPF_REQUESTID nvarchar (255) NOT NULL ,
- COGIPF_STEPID nvarchar (255) NULL ,
- COGIPF_SUBREQUESTID nvarchar (255) NULL ,
- COGIPF_THREADID varchar (255) NULL ,
- COGIPF_COMPONENTID varchar (64) NULL ,
- COGIPF_BUILDNUMBER int NULL ,
- COGIPF_LOG_LEVEL int NULL ,
- COGIPF_REPORT_TYPE varchar (255) NULL ,
- COGIPF_REPORT_PATH nvarchar (512) NULL ,
- COGIPF_STATUS varchar (255) NULL ,
- COGIPF_ERRORDETAILS nvarchar (2000) NULL,
- COGIPF_EVENT_TYPE varchar (255) NULL,
- COGIPF_REPORT_NAME nvarchar (255) NULL,
- COGIPF_STORE_ID nvarchar (255) NULL,
- COGIPF_RUNTIME int NULL,
- COGIPF_DEVICE_ID nvarchar (255) NULL,
- COGIPF_CLIENT_CATEGORY nvarchar (255) NULL,
- COGIPF_USER_AGENT nvarchar (512) NULL,
- COGIPF_USER_NAME nvarchar (512) NULL,
- COGIPF_USER_UID nvarchar (255) NULL
- )
- create index COGIPF_MOBILE_IDX on COGIPF_MOBILESERVICE (COGIPF_REQUESTID, COGIPF_USER_UID)
|
