0 - 1 of 1 tags for avoid junk characters in fastexported flat file..

hi,

I was exporting the DBC table DBQLSQLTBL using FASTEXPORT.But it is generating some junk characters
in the flat file.The below is the Fastexport script i used.

FASTEXPORT :
==========
begin export

sessionS 8;

.export outfile D:\Teradata\DBC_Scripts\SCRIPT_FILES\dbqlexplaintbl.txt
FORMAT TEXT MODE RECORD
outlimit 100;

SELECT
cast(cast(ProcID AS CHAR(5))||'|'||
cast(CollectTimeStamp AS CHAR(19))||'|'||
cast(QueryID AS CHAR(18))||'|' ||