Re: dbaccess output width
In article <7hbr9s$k5b$1@pollux.ip-plus.net>,
"EA" <appshome@geocities.com> wrote:
> Is it possible to set the line width of dbaccess output?
> I'm running dbaccess in batch mode redirecting the output into a file.
> I've tried all environment variables (i.e. Unix environment variables;
I
> didn't find any relevant Informix environment variables in the IDS and
> DBACCESS documentation) I could think of, dbaccess seems to ignore
them all.
> If the added length of all selected columns is greater than 80 it
won't put
> them all in one line (which is what I would need) but instead lists
them
> underneath each other.
>
> Environment: Informix Online Server 7.13 on Solaris 2.5.1
>
> Any help would be greatly appreciated.
>
> Cheers
> E.
>
>
Try using an unload statement to get the output into a file. For
example:
unload to 'my_file.out' select abc, def, ..., xyz from table1;
It will come out as a pipe (|) delimited file instead of fixed-width,
but each row will be on one logical line. You should then be able to
use and/or format this data in any application that can read a delimited
file. HTH.
Kind regards,
--
<><><><><><><>
John Bejarano
San Mateo, CA
<><><><><><><>
--== Sent via Deja.com http://www.deja.com/ ==--
---Share what you know. Learn what you don't.---