Redbrick List Forum

RE: SEGMENT LIKE DATA

Posted By: William Raper
Date: Wednesday, 9 July 2003, at 8:16 a.m.

In Response To: SEGMENT LIKE DATA (ADAM MCGUINNESS)

Adam

Here comes the awful, brutal answer: Prior to 6.2 SEGMENT LIKE DATA simply
does not work.

You must do the segmentation of your index manually.

They say that it is fixed in 6.2, but I have not yet tried it.

Bill

-----Original Message-----
From: ADAM MCGUINNESS [mailto:amcguinness@qbe.com.au]
Sent: Tuesday, July 08, 2003 11:59 PM
To: redbrick-list@iiug.org
Subject: SEGMENT LIKE DATA [102]


Hi

Redbrick 6.11
Solaris 2.7

I am trying to use the "SEGMENT LIKE DATA" clause when creating a star index
as found in SQLREF.PDF on the CD:

create star index sales_star_idx on sales
(sales_date_fkc, sales_product_fkc, sales_store_fkc,
sales_promo_fkc)
in (sales_star_seg1, sales_star_seg2) segment like data;

When I attempt to use the above SQL in AROMA the example database supplied,
I get "[Red Brick][ODBC Driver][Warehouse]** ERROR ** (87) Invalid syntax
'...)SEGMENT LIKE <==>DATA'"

What I am actually trying to do is create the index as specified below, but
I still get the syntax error.

CREATE STAR INDEX FACTS_CLAIM_TRANSACTIONS_STAR_PK ON
FACTS_CLAIM_TRANSACTIONS (
ACCOUNTING_MONTH_KEY,
SOURCE_SYSTEM_KEY,
CLAIM_STATUS_KEY,
CLAIM_TRANS_TYPE_KEY,
GST_DETAIL_KEY,
CLAIM_CATEGORY_KEY,
ORG_UNIT_KEY,
POLISY_PRODUCT_KEY,
DWH_PRODUCT_KEY,
ACCOUNTING_DATE_KEY,
IM_AGREEMENT_KEY,
LIABILITY_DETAILS_KEY,
POLICY_KEY,
INSURED_RISK_KEY,
CLAIMED_RISK_KEY,
CLAIM_KEY
)

IN ( FACTS_CLAIM_TRANSACTIONS_STAR_PK_1994,
FACTS_CLAIM_TRANSACTIONS_STAR_PK_1995,
FACTS_CLAIM_TRANSACTIONS_STAR_PK_1996,
FACTS_CLAIM_TRANSACTIONS_STAR_PK_1997,
FACTS_CLAIM_TRANSACTIONS_STAR_PK_1998,
FACTS_CLAIM_TRANSACTIONS_STAR_PK_1999,
FACTS_CLAIM_TRANSACTIONS_STAR_PK_2000,
FACTS_CLAIM_TRANSACTIONS_STAR_PK_2001,
FACTS_CLAIM_TRANSACTIONS_STAR_PK_2002,
FACTS_CLAIM_TRANSACTIONS_STAR_PK_2003,
FACTS_CLAIM_TRANSACTIONS_STAR_PK_2004,
FACTS_CLAIM_TRANSACTIONS_STAR_PK_2005,
FACTS_CLAIM_TRANSACTIONS_STAR_PK_2006,
FACTS_CLAIM_TRANSACTIONS_STAR_PK_2007,
FACTS_CLAIM_TRANSACTIONS_STAR_PK_2008,
FACTS_CLAIM_TRANSACTIONS_STAR_PK_2009,
FACTS_CLAIM_TRANSACTIONS_STAR_PK_2010 )
SEGMENT LIKE DATA;


Any ideas?

Thanks

Adam

Messages In This Thread

• SEGMENT LIKE DATA
  ADAM MCGUINNESS -- Tuesday, 8 July 2003, at 11:58 p.m.
  • RE: SEGMENT LIKE DATA
    William Raper -- Wednesday, 9 July 2003, at 8:16 a.m.
  • RE: SEGMENT LIKE DATA
    Chapman, Justin -- Wednesday, 9 July 2003, at 9:18 a.m.
  • Re: SEGMENT LIKE DATA
    ADAM MCGUINNESS -- Wednesday, 9 July 2003, at 6:54 p.m.

Redbrick List Forum is maintained by Administrator with WebBBS 5.12.