Archives of the TeradataForum

Message Posted: Wed, 29 Oct 2003 @ 11:04:15 GMT

	<Prev	Next>		<<First	<Prev	Next>	Last>>

Here are the table definitions:

-----------cut here-------------
CREATE SET TABLE drated_cdr_gsm_net_msum ,NO FALLBACK ,
     NO BEFORE JOURNAL,
     NO AFTER JOURNAL
     (
      bill_month DATE FORMAT 'YYYYMMDD' NOT NULL,
      visit_city_code CHAR(5) CHARACTER SET LATIN NOT CASESPECIFIC NOT NULL,
      srvc_brand_id CHAR(4) CHARACTER SET LATIN NOT CASESPECIFIC NOT NULL,
      call_type CHAR(2) CHARACTER SET LATIN NOT CASESPECIFIC NOT NULL,
      bsc CHAR(5) CHARACTER SET LATIN NOT CASESPECIFIC NOT NULL,
      lac CHAR(5) CHARACTER SET LATIN NOT CASESPECIFIC NOT NULL,
      msc VARCHAR(10) CHARACTER SET LATIN NOT CASESPECIFIC NOT NULL,
      trunk_grp_out CHAR(7) CHARACTER SET LATIN NOT CASESPECIFIC NOT NULL,
      trunk_grp_in CHAR(7) CHARACTER SET LATIN NOT CASESPECIFIC NOT NULL,
      call_duration DECIMAL(14,0) NOT NULL,
      chrg_unit60_cnt DECIMAL(12,0) NOT NULL,
      chrg_unit6_cnt DECIMAL(12,0) NOT NULL,
      call_cnt DECIMAL(10,0) NOT NULL,
      update_dt TIMESTAMP(0) FORMAT 'YYYYMMDDHHMISS' NOT NULL DEFAULT
CURRENT_TIMESTAMP(0))
PRIMARY INDEX rated_cdr_gsm_net_ms_upi ( bill_month ,visit_city_code ,
srvc_brand_id ,call_type ,bsc ,lac ,msc ,trunk_grp_out ,trunk_grp_in );

CREATE SET TABLE cde_caldate_wtab ,NO FALLBACK ,
     NO BEFORE JOURNAL,
     NO AFTER JOURNAL
     (
      cal_date DATE FORMAT 'YYYYMMDD' NOT NULL,
      cal_year_no CHAR(4) CHARACTER SET LATIN NOT CASESPECIFIC NOT NULL,
      cal_year_desc VARCHAR(10) CHARACTER SET LATIN NOT CASESPECIFIC NOT NULL,
      cal_year_day CHAR(3) CHARACTER SET LATIN NOT CASESPECIFIC NOT NULL,
      cal_qtr_no CHAR(1) CHARACTER SET LATIN NOT CASESPECIFIC NOT NULL,
      cal_qtr_desc VARCHAR(10) CHARACTER SET LATIN NOT CASESPECIFIC NOT NULL,
      cal_month_no CHAR(2) CHARACTER SET LATIN NOT CASESPECIFIC NOT NULL,
      cal_month_desc VARCHAR(10) CHARACTER SET LATIN NOT CASESPECIFIC NOT NULL,
      cal_month_day CHAR(2) CHARACTER SET LATIN NOT CASESPECIFIC NOT NULL,
      cal_month_day_desc VARCHAR(10) CHARACTER SET LATIN NOT CASESPECIFIC NOT NULL,
      cal_qtr_month_no CHAR(1) CHARACTER SET LATIN NOT CASESPECIFIC NOT NULL,
      cal_qtr_month_desc VARCHAR(10) CHARACTER SET LATIN NOT CASESPECIFIC NOT NULL,
      cal_month_week_no CHAR(1) CHARACTER SET LATIN NOT CASESPECIFIC NOT NULL,
      cal_month_week_desc VARCHAR(10) CHARACTER SET LATIN NOT CASESPECIFIC NOT NULL,
      cal_year_week_no CHAR(2) CHARACTER SET LATIN NOT CASESPECIFIC NOT NULL,
      cal_year_week_desc VARCHAR(10) CHARACTER SET LATIN NOT CASESPECIFIC NOT NULL,
      is_holiday CHAR(1) CHARACTER SET LATIN NOT CASESPECIFIC NOT NULL,
      is_weekend CHAR(1) CHARACTER SET LATIN NOT CASESPECIFIC NOT NULL)
UNIQUE PRIMARY INDEX cde_caldate_upi ( cal_date );
-----------cut here--------------------------------------------

BTW,
The currently running PDE version: 05.00.00.26
The currently running TPA version: 05.00.00.26
The currently running TGTW version: 05.00.00.02

Thanks for your help:-)

Bai Yihui

	<Prev	Next>		<<First	<Prev	Next>	Last>>