Problem with Fexp

Tools
Fan

Problem with Fexp

Hi,
I´m trying to execute a Fastexport and I have so problems with de output.

.LOGTABLE D_WRK.LGTB;
.LOGON 10.10.19.11/DBC,;

.BEGIN EXPORT
SESSIONS 2;

.EXPORT OUTFILE C:\tmp\OUTPUT.txt
MODE RECORD
FORMAT TEXT
;

SELECT
Acctng_Security_Type_Desc AS Acctng_Security_Type_Cd
FROM
D_DW_TABLES.ACCOUNTING_SECURITY_TYPE
;

.END EXPORT ;

.LOGOFF ;

And, this is the generated file>

 DESCRIPTION 1
% DESCRIPTION 2

DESCRIPTION 3
 DESCRIPTION 4

What are these strange characters ? How can I remove them ?

Thanks in advance
1 REPLY
Junior Supporter

Re: Problem with Fexp

This characters are the bytes that indicate the size of the VARCHARS following. CAST the columns to CHAR() in the SELECT statement in order to eliminate them.

Cheers.

Carlos.