|
Home > Archive > IQ Server > March 2006 > unload in sql (?)
You are viewing an archived Text-only version of the thread.
To view this thread in it's original format and/or if you want to reply to
this thread please [click here]
|
|
|
| hi,
how can i unload a table into txt file with no comma delimiter,
SET TEMPORARY OPTION Temp_Extract_Column_
Delimiter = '|';
select *
from table1
> # i:\table.txt,
this statement not work (i have still comma delimiter)...
--
dhc
| |
|
| Try the following instead
SET TEMPORARY OPTION Temp_Extract_Name1 = 'i:\table.txt';
SET TEMPORARY OPTION Temp_Extract_Column_
Delimiter = '|';
select * from table1
> hi,
>
> how can i unload a table into txt file with no comma
> delimiter,
>
> SET TEMPORARY OPTION Temp_Extract_Column_
Delimiter = '|';
> select *
> from table1
>
> this statement not work (i have still comma delimiter)...
>
>
> --
> dhc
|
|
|
|
|