Archives of the TeradataForum
Message Posted: Fri, 13 Jul 2001 @ 21:30:41 GMT
The FastExport utility itself doesn't do that sort of data conversion. But you can CAST the field to character instead of integer in your SELECT:
SELECT CAST(intfld AS CHAR(11)) FROM ...
You can also use CAST to apply a different format if you don't like the default:
CAST(CAST(intfld AS FORMAT '+9(10)') AS CHAR(11))
|Copyright 2016 - All Rights Reserved|
|Last Modified: 28 Jun 2020|