Archives of the TeradataForum
Message Posted: Fri, 10 Dec 2004 @ 22:58:00 GMT
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.
|Copyright 2016 - All Rights Reserved|
|Last Modified: 28 Jun 2020|