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:[EMAIL PROTECTED] On Behalf Of Muthukumar Kannaiyan Sent: Monday, November 14, 2005 10:08 AM To: [email protected] 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
