Re: SQL Help

There isn't really a perfect way to do what you want in the web gui.

For HL_NAME, the defined width of the column is 1024, and for LL_NAME,
the width of the column is 512.

One thing you can do is use the admin command line version of the client
(not the web GUI) with the -commadelimited option and redirect the
output to a file.  That will give you a comma-delimited file you can
view with EXCEL.

The other thing you can do is to limit the size of the columns like
this:

select left(hl_name,30) as "directory                     ",
left(ll_name,30) as "file                                          "
from backups where node_name='PRATHW1-WD1'

That's not a perfect solution, but may give you most of what you need.

Wanda Prather
"I/O, I/O, It's all about I/O"  -(me)








-----Original Message-----
From: ADSM: Dist Stor Manager [mailto:ADSM-L AT VM.MARIST DOT EDU] On Behalf Of
Muthukumar Kannaiyan
Sent: Monday, November 14, 2005 10:08 AM
To: ADSM-L AT VM.MARIST DOT EDU
Subject: SQL Help


I am executing following sql statement in web GUI. I want output to be
in
column/row format whereas I get each column in separate line. I tried
"Set
sqldisplaymode wide", but no use. Any idea!!!

select hl_name as "Directory
Name..................................................",ll_name "File
Name.................." from backups where node_name='EMCMON-H'

Thanks
Muthu