Home Page for the TeradataForum

Archives of the TeradataForum

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

  <Prev Next>  
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

            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>  
Next> Last>>  
  Top Home Privacy Feedback  
Copyright for the TeradataForum (TDATA-L), Manta BlueSky    
Copyright 2016 - All Rights Reserved    
Last Modified: 28 Jun 2020