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?
SELECT CAST(('' ||
(CAST('UD ' AS CHAR(3))) ||
(CAST(B.column1 AS CHAR(2))) ||
(CAST(B.columnN AS CHAR(6)),''))) AS CHAR(550)) (title '')
Doneth, please help me..really stuck with this issue and time is very short..any help will be highly appriciated..Thanks in advance.
Your source code is not FastExport, but BTEQ syntax.
BTEQ will never export trailing blanks.
When you actually use FastExport you'll get what you want.
you can use a work around with bteq add a dummy column of '|' to the end and later replace the pipe with space or null
Thanks for the reply. Can you please how can I Actually use Fastexport in this case? Thanks a lot. I know I am asking very silly question but can't help it.
Even after adding a dummy column of '|' is not working.
Even after adding "|" at the end of each column I am getting data till 76th byte only.
It will be better if I can get the full length file by adding any special character at the end of the each column. I can remove that later.Any help highly appriciated as i need any solution very soon.