Gabe asks:
>>How can I use DBACCESS to get my output select statement in columns
>>instead
>>of row format?
You can also limit characters returned by using the [n,m] after the
column name in your sql statement. This might be an alternative if
you cannot select fewer columns.
i.e. SELECT a.name[1,8] dbspace,
b.fname[1,25] device,
c.reads phy_reads,
c.writes phy_writes
FROM sysdbspaces a,
syschunks b,
syschkio c
WHERE a.dbsnum = b.dbsnum
and b.chknum = c.chunknum;
>Selecting fewer columns. Once the number of columns causes the data
>to exceed the screen width it automagically shifts to "row format."
>Or manipulate the output after selection. That's much of what 4GL
>does best.
___________________________________________________________
Clem Akins (aka clem@informix.com)
Informix Software, Inc (Standard disclaimers apply)
International Technical Support
Last seen: Prepping for a (short) Sierra Nevada adventure...