|
|
|
Forum Newbie
Group: Forum Members
Last Login: 8/8/2008 2:33:30 PM
Posts: 2,
Visits: 12
|
|
Hi,
I need to create a delimited file using fastexport. As fast export do not support delimited format, so I have written the select to get the delimited output. But the following script prefix each line with 2 junk characters.
[Script]
.LOGTABLE tempdb.xxlogtable;
.LOGON TD_DB/USER1,PASS1;
.BEGIN EXPORT SESSIONS 7
DATAENCRYPTION OFF;
.EXPORT OUTFILE SALIDA.txt
MODE RECORD
FORMAT TEXT;
select
trim(col1) || '|' ||
trim(col2) || '|' ||
trim(col3) || '|' || ...........
...............................
trim(col50)
from table
.END EXPORT;
.LOGOFF;
[Output]
#.R1Field1|R1Field2|...
_:R2Field1|R2Field2|...
...........................
[Desidered Output]
R1Field1|R1Field2|...
R2Field1|R2Field2|...
...........................
I cannot cast the output as char(xxx) as it will increase the size of the output file.
I'm running Fastexport V.07.08.00.000 Win32 plataform.
Any kind of suggestions is highly appreciated.
Thanks,
Jorge
|
|
|
|
|
Forum Member
Group: Forum Members
Last Login: 9/17/2008 6:21:35 AM
Posts: 30,
Visits: 105
|
|
GIVE each column datatype and length ok
SHEEBA
|
|
|
|
|
Forum Newbie
Group: Forum Members
Last Login: 10/13/2008 11:51:09 AM
Posts: 5,
Visits: 6
|
|
Hello Jorge,
As Fastexport delimited format will add 2 binary character for the length of the record. however if any one can give idea how to ignore 2 binary character in mload.
Thanks in advance!!
Rajendran
Regards,
Rajendran
|
|
|
|
|
Supreme Being
Group: Forum Members
Last Login: 11/12/2008 9:19:53 PM
Posts: 469,
Visits: 463
|
|
|
if your purpose is to fastexport from one table and mload else where, why don't you make use of the mlscript option of fastexport ?
|
|
|
|