Home Page for the TeradataForum
 

Archives of the TeradataForum

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


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


Subj:   Re: Getting 3916 errocode
 
From:   Jha, Pankaj

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>>  
 
 
 
 
 
 
 
 
  
  Top Home Privacy Feedback  
 
 
Copyright for the TeradataForum (TDATA-L), Manta BlueSky    
Copyright 2016 - All Rights Reserved    
Last Modified: 15 Jun 2023