|
|
|
Forum Newbie
Group: Forum Members
Last Login: 11/5/2009 6:07:39 AM
Posts: 9,
Visits: 10
|
|
Hi
In UNIX, I have fast exported 10 rows from source table(2 columns--item_id, site_id) to dw_abc(text format).
For eg: .export outfile dw_abc format text; ** this is the syntax i have used.
-------
10 rows got exported, but the problem is when i was opened the output file "dw_abc" in UNIX. It was showing like this.
item_id site_id
100 200
300 400
500 600
700800 ------------- item_id, site_id were not separated
900 1000
101201-------------item_id, site_id were not separated
301 401
501601-------------item_id, site_id were not separated
701 801
901 1001
Some of the item_id, site_id got separted by tab as a delimiter. Some item_id, site_id's were not separted. I want, all the item_id, site_id should be separated by tab as a delimiter.
Can anyone explain?
Thanks for ur support!!!
Thanks,
Guru
|
|
|
|
|
Forum Member
Group: Forum Members
Last Login: 11/9/2009 3:27:04 PM
Posts: 38,
Visits: 46
|
|
FastExport does not support the exporting of data in delimited format.
I am sure that the column values were not separated by TAB whitespace characters.
TEXT format just writes the data in a format that comprises of the column data followed by end-of-record marker (newline).
|
|
|
|