select node_name as "+++++++++ Node Name+++++++++++++++++++" from nodes.
Put in as many fill chars as you need to force the output to be as wide as your widest node name. -----Original Message----- From: Gerald Wichmann [mailto:[EMAIL PROTECTED]] Sent: Wednesday, May 29, 2002 7:16 PM To: [EMAIL PROTECTED] Subject: select formatting 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- 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)
