Re: Output from dbaccess
Posted in 2000
--- "Bryan Osborne" <bryan.osborne@wilcom.com>
> wrote:
>What do I modify/set to get dbaccess to output in a "long column list"
>format instead of the "individually labeled record" format, i.e.,
>
>col1_name col2_name
>record1val1 record1val2
>record2val1 record2val2
>
>instead of:
>
>col1_name record1val1
>col2_name record1val2
>
>col1_name record2val1
>col2_name record2val2
>
>I have one instance which outputs one way and another which outputs the
>other.
>
dbaccess will only do what you want if the combined length of the colname/coldata and a few spaces here and there can fit within the 80 char confines of the viewing window. For more flexibility check out Mr. Leffler's sqlcmd at the iiug.org repository.
==
Maintainer of the procrastinator's FAQ. Well, maybe tomorrow I will be.
_____________________________________________________________
Want a new web-based email account ? ---> http://www.firstlinux.net