Re: dbaccess format question
In article <343E84A7.794BDF32@srv.pacbell.com>,
Thomas Goetze <tegoetz@srv.pacbell.com> wrote:
>
>echo 'select * from table' | dbacess db_name > output.file
>
>Which works, but the output has one column per line
>and the column header is listed before each element.
>Obviously this takes up way too much space. Can I get
>the output to have one row per line and have each
>column separated by "|"'s. I sure hope so.
You might try this:
echo "unload to 'output.file' select * from table' | dbaccess db_name
This will give you variable-width fields though - is that OK?
- Paul
(not a spokesman)