Fastexport is not creating full length file

Database
Enthusiast

Fastexport is not creating full length file

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?

.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,

Terankit

7 REPLIES
Enthusiast

Re: Fastexport is not creating full length file

Doneth, please help me..really stuck with this issue and time is very short..any help will be highly appriciated..Thanks in advance.

Terankit

Senior Apprentice

Re: Fastexport is not creating full length file

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.

Dieter

Enthusiast

Re: Fastexport is not creating full length file

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

Enthusiast

Re: Fastexport is not creating full length file

Hi Doneth,

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.

Enthusiast

Re: Fastexport is not creating full length file

Hi Doneth,

Even after adding a dummy column of '|' is not working.

Enthusiast

Re: Fastexport is not creating full length file

Even after adding "|" at the end of each column I am getting data till 76th byte only.

Enthusiast

Re: Fastexport is not creating full length file

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.

Thanks.