Fast export in UNIX using Teradata creating issue

view full story

http://www.unix.com – Hi All, I am trying to export a file using Fast Export (Teradata) in UNIX. The desired output length is 550 bytes, but the output file is creating string till 75 characters. How to get the full length file? Code: .LOGON .EXPORT file=export.txt; SELECT CAST(('' || (CAST('UD ' AS CHAR(3))) || (CAST(B.column1 AS CHAR(2))) || : : (CAST(B.columnN AS CHAR(6)),''))) AS CHAR(550)) (title '') FROM Table1; .EXPORT RESET; .LOGOFF; Thanks. (HowTos)