You can also:

select cast(filespace_name as char(40)) as "Filespace
Name"..................

John Monahan
Senior Consultant Enterprise Solutions
Computech Resources, Inc.
Office: 952-833-0930 ext 109
Cell: 952-484-5435
http://www.compures.com





Andrew Raibeck <storman AT US.IBM DOT COM>
Sent by: "ADSM: Dist Stor Manager" <ADSM-L AT VM.MARIST DOT EDU> 02/16/2002 
07:11
AM Please respond to "ADSM: Dist Stor Manager"


        To:     ADSM-L AT VM.MARIST DOT EDU
        cc:
        Subject:        Re: Select statement


Are you asking how to increase the width so that
the file space name doesn't wrap to multiple
lines?

While this example doesn't wrap, it does illustrate
a method you can use to adjust the output column
widths.



STANDARD WIDTH:

select filespace_name, node_name, capacity from filespaces

FILESPACE_NAME         NODE_NAME                          CAPACITY
------------------     ------------------     --------------------
\\raibeck\c$           RAIBECK                             44481.4
\\raibeck\c$           RAIBECK                             44481.4



CUSTOM WIDTH (40 columns for FILESPACE_NAME):

select filespace_name as "FILESPACE NAME                          ",
       node_name, capacity from filespaces

FILESPACE NAME                               NODE_NAME      CAPACITY
----------------------------------------     ------------------
--------------------
--------------------
\\raibeck\c$                                 RAIBECK       44481.4
\\raibeck\c$                                 RAIBECK       44481.4

Note: The "as" specification for FILESPACE_NAME is padded
with blanks to bring the entire column width to 40.

When running in batch mode, if you want the display to
appear in tabular format rather than list format, put
the select command in a macro, say, "select.mac". Then
invoke dsmadmc like this:



dsmadmc -id=adminid -pa=xxxxx -displaymode=table
        macro select.mac



or like this this to redirect output to a file:



dsmadmc -id=adminid -pa=xxxxx -displaymode=table
        macro select.mac > select.out 2>&1



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

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


From: Hunley, Ike [mailto:Ike.Hunley AT BCBSFL DOT COM]
Sent: Friday, February 15, 2002 4:36 PM
To: ADSM-L AT VM.MARIST DOT EDU
Subject: Select statement


Hi all,

I hope someone out there has the answer for this.
How do I increase the output field size for
filespace_name so I can output the filespace_name
along with quantity and node_name?

Thanks