COGNOS QUERY
STRUCTURE,1,1
DATABASE, cognos
TITLE,test
BEGIN SQL
{
select
time,
city_id,
city_name,
center_id,
center_name,
region,
city_name_abb,
cou
from TF_ORGA t
}
END SQL
COLUMN,0,查询时间
COLUMN,1,地市ID
COLUMN,2,地市名称
COLUMN,3,区域中心ID
COLUMN,4,区域中心名称
COLUMN,5,地区
COLUMN,6,缩写字母名称
COLUMN,7,伪度量列
---------------------------------------------------------------------
cs7g.ini 信息(10.2.1版本)
;
; IBM Confidential
;
; OCO Source Materials
;
; A and PM: TR
;
; (C) Copyright IBM Corp. 1996, 2010
;
; The source code for this program is not published or otherwise
; divested of its trade secrets, irrespective of what has been
; deposited with the U.S. Copyright Office.
;
[Location]
Install Location=.\
Rendition Base Location=.\
; IBM Confidential
;
; OCO Source Materials
;
; A and PM: TR
;
; (C) Copyright IBM Corp. 1996, 2010
;
; The source code for this program is not published or otherwise
; divested of its trade secrets, irrespective of what has been
; deposited with the U.S. Copyright Office.
;
[Location]
Install Location=.\
Rendition Base Location=.\
[Services]
COGNLSTAB=.\coglang.tab
SRVCMSGS=.\srvcmsgs_en.msg
CTDBA=ctdba,ctdba15
COGNLSTAB=.\coglang.tab
SRVCMSGS=.\srvcmsgs_en.msg
CTDBA=ctdba,ctdba15
[Databases]
cognos=^User ID:^?Password:;LOCAL;OR;ORACLE@%s@(DESCRIPTION =(ADDRESS_LIST =(ADDRESS = (PROTOCOL = TCP)(HOST =127.0.0.1)(PORT = 1521)))(CONNECT_DATA =(SERVICE_NAME =ORCL)))/%s@COLSEQ=