Re[2]: DBACCESS Select output in colums

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...