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
|