Hi, I am using fastexport to exp

[arzoocbe]

Hi,

I am using fastexport to export the data.
The following is the output for the below mentioned script,


^K1915328213
^K1853442387
^K1832253921
^K1314530978


I would like to know why my output is always preceded by a '^K' character
how can I remove the control Character.

Any help is appreciated.

Thanks in Advance.
arzoo


Script
------

.logtable RestartLog;

.logon TDPid/user1,XXXXXX;

.begin export sessions 2;

.export outfile SampleSpool3;

select cast(field1 AS CHAR(10)), cast(field2 as CHAR(3)),
cast(field3 as CHAR(3))
from table1;

.end export;

.logoff;

.exit;

 

[dirklieske]

I don't know why but I know what. You are seeing a vertical tab which sometimes shows up as a line feed. What editor are you using to look at you output?

Cheers Dirk

 

[dnoeth]

You didn't specify the output format, so it defaults to FASTLOAD and this is including a 2 byte unsigned integer indicating the record length.
Try a
.export outfile format text ...

Dieter

 

[arzoocbe]

Thanks Dieter I fixed it,

Thanks for the inputs