Home Page for the TeradataForum
 

Archives of the TeradataForum

Message Posted: Mon, 17 Jul 2006 @ 19:26:28 GMT


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


Subj:   3527 error - Format string 'YYYYMMDDHHMISS' has combination of numeric, character and GRAPHIC values
 
From:   Pandey, Vivek

Hi Folks,

Any idea regarding the below error. I am not able to follow the vocabulary what Teradata manual gives about this one.

     ct ts2(a timestamp(0));

     UPDATE ts2
     Set a = NULLIF( '20060717121212', '????????????? ' )(FORMAT 'YYYYMMDDHHMISS');


     3527:? Format string 'YYYYMMDDHHMISS' has combination of? numeric,
     character? and GRAPHIC values.

3527 Format string '%VSTR' has combination of numeric, character and GRAPHIC values.

Explanation: The specified format contains X characters, characters that imply numeric values and/or G characters, for example, the digit 9, the dollar sign, period, dash, plus sign, comma, character G, or character X.

Generated By: OPT modules.

For Whom: End User.

Remedy: Correct the format.


Thanks, Vivek



     
  <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