Archives of the TeradataForum

Message Posted: Tue, 28 Sep 2010 @ 21:34:03 GMT

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

Hi - thanks in advance for your help.

I am trying to create a join index (JI).

I am getting an error message -- 5464 (pretty generic per the Messages Manual) with the following explanation:

"Error in JI DDL. Only columns, extract, SUM, COUNT expressions with aliases are allowed in select list."

A few comments about the DDL below: tables are aliased with "E" or "I" and these table aliases are used to qualify the actual attributes in the select list.

     CREATE JOIN INDEX CFDW2_erisk_access_tbls.AJI_glb_fmly_exp_n_Mstrsrch_4
                      ,NO FALLBACK ,CHECKSUM = DEFAULT AS

     SELECT
       CFDW2_iris_tbls.I.mstr_prty_id
     , sum ( CFDW2_iris_tbls.I.nrm_IFG_polcy_5_expos_amt)
     , sum ( CFDW2_iris_tbls.I.nrm_IFG_tot_expos_amt)
     , sum ( CFDW2_iris_tbls.I.nrm_GEI_polcy_5_expos_amt)
     , sum ( CFDW2_iris_tbls.I.nrm_GEI_tot_expos_amt)

     FROM CFDW2_erisk_access_tbls.master_party_hist E
               , CFDW2_iris_tbls.CS_MASTER_PARTY_CALC I

     WHERE cfdw2_iris_tbls.I.mstr_prty_id =
                    CAST (CFDW2_erisk_access_tbls.E.ucm_entrprs_prty_id as
     Varchar (256))
     and cfdw2_erisk_access_tbls.E.ectl_end_dt = DATE '9999-12-31'

     GROUP BY 1

     PRIMARY INDEX ( mstr_prty_id );

Any thoughts on the error(s)?

Any recommendations on where to read about JIs?

Any known classes in the TENs network that U recommend for JI instruction?

Thanks,

Bill Gregg
GE-Capital

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