Home Page for the TeradataForum

Archives of the TeradataForum

Message Posted: Wed, 01 Mar 2006 @ 13:56:01 GMT

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

Subj:   Re: Getting 3916 errocode
From:   Victor Sokovin

  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 workingexcept giving 3916 errorcode sometimes.  

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

I don't think so. The GROUP BY looks fine.

Do you (re)create some source tables (or perhaps the target table itself) just before executing the INSERT INTO? If you do, there might be some latency in the dictionary: the new object is created but the dictionary is not yet quite "ready" to provide information on it.

What you could try is add the following command just before your INSERT INTO:

     .HANG 1

It will instruct bteq to pause for 1 sec (perhaps a couple of seconds is safer?) before proceeding with the INSERT INTO. This does not cure the problem but will perhaps reduce the number of errors and give you the time to think about the source of the problem. I'm afraid that's the only suggestion I can come up with right now.



  <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: 28 Jun 2020