Fast Export fixed width format issue

Connectivity

Fast Export fixed width format issue

Hi,

I have four columns in table which declared as char in table defination and it contains the numaric values. when i write a fast export script with fixed lenght, i am not getting expected result. Can you please tell me how do we correct this.

Here is the code

.LOGTABLE lci_work_tbls.test_LOG1 ;
.BEGIN EXPORT SESSIONS 20 TENACITY 4 SLEEP 10;
.EXPORT OUTFILE outputfile.dat MODE RECORD FORMAT TEXT;

LOCKING ROW FOR ACCESS
SEL
CAST(STR_NO AS CHAR(5))
,CAST(TERM_NBR AS CHAR(3))
,CAST(TRAN_LN_NBR AS CHAR(4))
,CAST(CPN_NBR AS CHAR(8))
,CAST(CPN_TYP_CD AS CHAR(1))
,CAST('I' AS CHAR(1))
from TABLE1
;
.END EXPORT ;

thanks
Vis