On Nov 14, 2005, at 10:08 AM, Muthukumar Kannaiyan wrote:

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

Don't try to use Web clients, in general, for sophisticated operations:
Web clients provide basic functionalities, and cannot provide all the
capabilities of a "real" client. The most you can do in that case is
use the browser's controls to make the font smaller.

For the utmost flexibility in performing queries like this, use the
command line interface (CLI), which is the dsmadmc command.
See the Admin Ref manual's doc for the -DISPLaymode option of dsmadmc,
whereby you can choose tabular or list format, or simply direct the
output to a file.
You might also consider the ODBC interface for issuing Select's.

   Richard Sims