One thing I've noticed is that if you run a script from the Admin Center
the output is in a different format.  SQLDISPLAYMODE doesn't make any
difference.

Here is a perfect example.  Run from the command line and then run from
inside Admin Center to see the difference.  Then try playing with
sqldisplaymode.

select node_name from nodes where collocgroup_name is null


______________________________
John Monahan
Consultant Infrastructure Solutions Group
Computech Resources, Inc.
Office: 952-833-0930 ext 109
Cell: 952-221-6938
http://www.computechresources.com




Andrew Raibeck <storman AT US.IBM DOT COM>
Sent by: "ADSM: Dist Stor Manager" <ADSM-L AT VM.MARIST DOT EDU>
09/22/2006 09:22 AM
Please respond to
"ADSM: Dist Stor Manager" <ADSM-L AT VM.MARIST DOT EDU>


To
ADSM-L AT VM.MARIST DOT EDU
cc

Subject
Re: Newbie question 2!






The -displaymode option is also a possibility. See the Admin Reference
chapter about using the command line interface for details.

Regards,

Andy

Andy Raibeck
IBM Software Group
Tivoli Storage Manager Client Development
Internal Notes e-mail: Andrew Raibeck/Tucson/IBM@IBMUS
Internet e-mail: storman AT us.ibm DOT com

IBM Tivoli Storage Manager support web page:
http://www-306.ibm.com/software/sysmgmt/products/support/IBMTivoliStorageManager.html


The only dumb question is the one that goes unasked.
The command line is your friend.
"Good enough" is the enemy of excellence.

"ADSM: Dist Stor Manager" <ADSM-L AT VM.MARIST DOT EDU> wrote on 09/22/2006
07:13:10 AM:

> Hey Angus,
>
> Are you talking about SQL statements appearing in a 'wide' format? If
> so, then 'set sqldisplaymode wide' will work for you >>>
> http://192.168.1.10:2297/help/topic/com.ibm.itsmmsmunn.doc/anrsrf53400.h
> tm
>
> Otherwise, certainly from my experience, as long as my terminal display
> is wide enough (for example, easy to resize in PuTTY) the output from
> queries will make use of the whole terminal width.
>
> Hope that helps,
>
> Rgds,
>
> David McClelland
> Data Protection Specialist
> IBM Tivoli Storage Manager Certified Consultant
> Reuters, London
>
> -----Original Message-----
> From: ADSM: Dist Stor Manager [mailto:ADSM-L AT VM.MARIST DOT EDU] On Behalf 
> Of
> Angus Macdonald
> Sent: 22 September 2006 08:51
> To: ADSM-L AT VM.MARIST DOT EDU
> Subject: [ADSM-L] Newbie question 2!
>
> How do I convince my console output to display in wide format, like in
> the redbooks? My course tutor did show me but that was 18 months before
> I touched Tivoli for real and it seemed so trivial I didn't make a note
> of it.
>
> Angus
>
>
> This email was sent to you by Reuters, the global news and
> information company.
> To find out more about Reuters visit www.about.reuters.com
>
> Any views expressed in this message are those of the individual
> sender, except where the sender specifically states them to be the
> views of Reuters Ltd.