Home Page for the TeradataForum
 

Archives of the TeradataForum

Message Posted: Tue, 09 Mar 2010 @ 15:48:34 GMT


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


Subj:   Self joins are not allowed in Join Index!!
 
From:   Ahmad, Syed

Hi,

I am running the below select query and it is running fine, once we want to create the join index it is giving the error that 5464: Error in Join Index DDL, Self joins are not allowed.

Any help would be definitely appreciated.

     CREATE JOIN INDEX WOFDWPRT.BUY_SELL_DLR_MV_JI AS

     SELECT BSD.DLR_SK BSD_DLR_SK, BSD.DLR_BUY_SELL_NBR BSD_DLR_NBR_NK,
            BSD.BUY_SELL_DLR_SK, BSD.DLR_NM BSD_DLR_NM, CLNT.CLNT_NBR BSD_CLNT_NBR,
            CLNT.CLNT_SK BSD_CLNT_SK,
            BSD.DLR_CLNT_CLSS_DESC BSD_DLR_CLNT_CLSS_DESC,
            BSD.DLR_BUY_SELL_NBR_D_SK, BSD.RGN_CD BSD_RGN_CD,
            BSD.RETL_DLR_FNDG_SRVC BSD_RETL_DLR_FNDG_SRVC,
            BSD.DLR_SALE_REP BSD_DLR_SALE_REP, BSD.RGN_NM BSD_RGN_NM,
            BSD.SET_DLR_IN BSD_SET_DLR_IN,
            BSD.RETL_DLR_REF_NBR BSD_RETL_DLR_REF_NBR,
            BSD.DLR_DBA_NM BSD_DLR_DBA_NM, BSD.DLR_ACTV_IN BSD_DLR_ACTV_IN,
            BSD.DLR_DRCT_INDR_IN BSD_DLR_DRCT_INDR_IN,
            BSD.SET_FLT_ID BSD_SET_FLT_ID,
            BSD.DLR_OUT_OF_BUSN_DT BSD_DLR_OUT_OF_BUSN_DT,
            BSD.DLR_ADDR_LN_1 BSD_DLR_ADDR_LN_1,
            BSD.DLR_ADDR_LN_2 BSD_DLR_ADDR_LN_2, BSD.DLR_CITY_NM BSD_DLR_CITY_NM,
            BSD.DLR_ZIP_CD BSD_DLR_ZIP_CD, BSD.DLR_ST_CD BSD_DLR_ST_CD,
            BSD.DLR_CNTY_NM BSD_DLR_CNTY_NM,
            BSD.DLR_CLNT_CLSN_1 BSD_DLR_CLNT_CLSN_1,
            BSD.DLR_CLNT_CLSN_2 BSD_DLR_CLNT_CLSN_2,
            BSD.DLR_WHSL_IN BSD_DLR_WHSL_IN,
            BSD.DLR_SPCL_GRP_NM BSD_DLR_SPCL_GRP_NM,
            BSD.DLR_STD_SPPT_IN BSD_DLR_STD_SPPT_IN,
            BSD.DLR_STD_PRFRD_ELITE_IN BSD_DLR_STD_PRFRD_ELITE_IN,
            BSD.DIST_CD BSD_DIST_CD, BSD.DW_BGN_DT, BSD.DW_STRT_DT, BSD.DW_END_DT,
            BSD.DW_DATA_SRC, BSD.DW_INSRT_MAP_NM, DLR.DW_CRRT_FL, BSD.DW_INSRT_TS,
            BSD.DW_LST_CHNG_TS, BSD.DW_DLT_FL, BSD.DW_LST_CHNG_MAP_NM,
            BSD.DW_ERR_FL, BSD.DLR_DRCT_INDR_UDF BSD_DLR_DRCT_INDR_UDF,
            BSD.DLR_TYPE BSD_BSD_DLR_TYPE, BSD.DLR_ACTV BSD_DLR_ACTV,
            BSD.DLR_PHN_NBR BSD_DLR_PHN_NBR, BSD.DLR_JMA_TERR BSD_DLR_JMA_TERR,
            DLR.DLR_D_SK DLR_D_SK, DLR.DLR_SK DLR_SK
        FROM WOFDWRPT.D_DLR BSD, WOFDWRPT.D_DLR DLR, WOFDWRPT.D_CLNT CLNT
        WHERE DLR.DLR_BUY_SELL_NBR_D_SK = BSD.DLR_D_SK
        AND DLR.DLR_BUY_SELL_NBR_D_SK <> -1
        AND CLNT.CLNT_NBR = BSD.CLNT_NBR_NK;

Thanks,

Syed



     
  <Prev Next>  
<<First
<Prev
Next> Last>>  
 
 
 
 
 
 
 
 
  
  Top Home Privacy Feedback  
 
 
Copyright for the TeradataForum (TDATA-L), Manta BlueSky    
Copyright 2016 - All Rights Reserved    
Last Modified: 27 Dec 2016