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