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:


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