The below output is from a simple select statement. I hate to ask this again
but its been a while since I've done it and I forget how to format the
columns. What I need to do is extract the node names from the backup server
so that I can then perform operations on them. How do I increase the width
of the column to get the desired effect? I suppose set sqldisplaymode would
do it but I'm actually running the select query from a perl script via a
dsmadmc command.

i.e.:

@RESULT = `/opt/Tivoli/tsm/client/admin/bin/dsmadmc -id=admin -pa=admin
"select node_name from nodes"`;

returns the below when what I want is to store the node names in an array

Obtaining list of nodes on backup server..
Tivoli Storage Manager
Command Line Administrative Interface - Version 4, Release 2, Level 2.0
(C) Copyright IBM Corporation, 1990, 2001, All Rights Reserved.

Session established with server SERVER1: Solaris 7/8
  Server Version 4, Release 2, Level 2.0
  Server date/time: 05/29/02   23:05:26  Last access: 05/29/02   22:54:56

ANS8000I Server command: 'select node_name from nodes'

NODE_NAME
------------------
ORION-41.8-10.0.1-
ORION-41.8-10.0.1-
 04.1
ORION-41.8-10.0.1-
 72.1
ORION-41.8-10.0.1-
 72.3
ORION-41.8-10.0.1-
 72.4
ORION-41.8-10.0.1-
 72.5
ORION-41.8-10.0.1-
 72.7
ORION-41.8-10.0.2-
 04.1
ORION-41.8-10.0.2-
 04.2
ORION-41.8-10.0.2-
 04.3
ORION-41.8-10.0.2-
 04.4
ORION-41.8-10.0.2-
 04.5
ORION-41.8-10.0.2-
 04.7

ANS8002I Highest return code was 0.

Regards,

Gerald Wichmann
Senior Systems Development Engineer
Zantaz, Inc.
925.598.3099 (w)