Home Page for the TeradataForum
 

Archives of the TeradataForum

Message Posted: Thu, 01 May 2003 @ 21:11:04 GMT


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


Subj:   Re: Received 3813 error message when using "Inset Explain"
 
From:   Fred W Pluebell

I suspect this QCD was created with (an older version of) DIPQCD script and the creating session was using ANSI date format. Check to see if it's the problem I remember:

select TableName, ColumnName, ColumnFormat
from dbc.columns where databasename = 'qcd' and columntype='da';

TableName ColumnName ColumnFormat
Query         DateTimeStamp YY/MM/DD

If you have a different ColumnFormat, that's the problem. One option would be to drop the QCD and re-create it using VE tools. Or just alter the format:

ALTER TABLE QCD.Query ADD DateTimeStamp DATE FORMAT 'YY/MM/DD';


Also, I'd recommend you explicitly specify the database name to be used for query capture:

INSERT EXPLAIN INTO qcDatabaseName AS myQueryLabel SELECT...



     
  <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