Home Page for the TeradataForum
 

Archives of the TeradataForum

Message Posted: Fri, 10 Dec 2004 @ 22:58:00 GMT


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


Subj:   BTEQ Format Question: Justify, zerofill and truncate
 
From:   Capp.Luckett

Another BTEQ formatting question:

I have a column defined as varchar (18). I need to right justify and zerofill the resulting output and truncate to 9 digits/characters.

Some of the data appears in my BTEQ output as '18' trailing blanks.

I have it defined as

     CAST(CAST(IDM.IDENTITY_ID AS FORMAT '9(09)')
            as char(11))

However I get an error message of: Failure 3617 FORMAT '9(09)' does not match the datatype

Any suggestions or were I can read about this or see sample code, I welcome it.


Capp Luckett



     
  <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