[prev in list] [next in list] [prev in thread] [next in thread] 

List:       adsm-l
Subject:    Re: select formatting
From:       "Seay, Paul" <seay_pd () NAPTHEON ! COM>
Date:       2002-05-30 23:39:13
[Download RAW message or body]

Select node_name as "Node Name                    " from Nodes

You may have to add -tab to your dsmadmc command.

Paul D. Seay, Jr.
Technical Specialist
Naptheon, INC
757-688-8180


-----Original Message-----
From: Gerald Wichmann [mailto:gwichman@ZANTAZ.COM]
Sent: Wednesday, May 29, 2002 7:16 PM
To: ADSM-L@VM.MARIST.EDU
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)

[prev in list] [next in list] [prev in thread] [next in thread]