Archives of the TeradataForum

Message Posted: Wed, 01 Mar 2006 @ 12:34:12 GMT

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

Victor,

Below is the example Bteq Script.

     INSERT INTO
                MY_target_table
     (col1
     ,col2
     ,col3
     ,col4
     ,col5
     ,col6
     )
     SELECT
      ROT.COL1
     ,ROT.COL2
     ,COM.COL3
     ,'MEAT,FISH & POULTRY'
     ,SUM(W2S.COL4)
     ,'OD'
     FROM  SOURCE_TABLE_1 W2S
      INNER JOIN  SOURCE_TABLE_2 ROT
      ON    (ROT.COL2=W2S.COL2)
      INNER JOIN  SOURCE_TABLE_3 COM
      ON(W2S.COL3 = COM.COL3)
       INNER JOIN
                 SOURCE_TABLE_4 DT
       ON (COM.COL4 = DT.COL1)
      WHERE W2S.COL1 IN ('M','V','U')
      GROUP BY 1,2,3
      ;

      *** Failure 3916 Requested information not in dictionary.
                     Statement# 1, Info =0
      *** Total elapsed time was 0.02 seconds.

This is the sample query and full errormessage.

What I found in this query very strange is the fact that "Group by" is being done on only first 3 columns. Quite surprisingly its working except giving 3916 errorcode sometimes.

Ideally group by clause should be done on 1,2,3,4,and 6. Is this the culprit?

Thanks,

Pankaj Jha
Software Engineer
MI-DEV
TESCO HSC
www.tescoindia.biz

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