Using AS to pad the column title length should do the trick. Make sure you
are using a sufficient amount of padding.

Alternatively, use the -tabdelimited or -commadelimted options, then load
the results into a spreadsheet or database tool; or use the ODBC driver.

Regards,

Andy

Andy Raibeck
IBM Software Group
Tivoli Storage Manager Client Development
Internal Notes e-mail: Andrew Raibeck/Tucson/IBM@IBMUS
Internet e-mail: storman AT us.ibm DOT com

The only dumb question is the one that goes unasked.
The command line is your friend.
"Good enough" is the enemy of excellence.

"ADSM: Dist Stor Manager" <ADSM-L AT VM.MARIST DOT EDU> wrote on 2005-03-21
08:31:24:

>    Hmm, I had already tried padding the columns and in the normal
> (narrow) mode, it still starts to line-wrap at 18 characters. In wide
> mode it then puts it in paragraph mode.
>
> Ben
>
> -----Original Message-----
> From: ADSM: Dist Stor Manager [mailto:ADSM-L AT VM.MARIST DOT EDU] On Behalf 
> Of
> Fred Johanson
> Sent: Friday, March 18, 2005 7:18 PM
> To: ADSM-L AT VM.MARIST DOT EDU
> Subject: Re: Sql query for file listings.
>
> Try 'select node_name as "Node",hl_name
> as "Directory                  ", etc.'
>
> The padding in the AS description serves to widen the column for hl_name
> (or whatever else).
>
> Fred Johanson