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 <[EMAIL PROTECTED]> Sent by: "ADSM: Dist Stor Manager" <ADSM-L@VM.MARIST.EDU> 09/22/2006 09:22 AM Please respond to "ADSM: Dist Stor Manager" <ADSM-L@VM.MARIST.EDU> To ADSM-L@VM.MARIST.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/[EMAIL PROTECTED] Internet e-mail: [EMAIL PROTECTED] 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@VM.MARIST.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:[EMAIL PROTECTED] On Behalf Of > Angus Macdonald > Sent: 22 September 2006 08:51 > To: ADSM-L@VM.MARIST.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.