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=.\

[Services]

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=