Re: Select statement
2015-10-04 17:12:14
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
|
<Prev in Thread] |
Current Thread |
[Next in Thread> |
- Re: Select statement, (continued)
- Re: Select statement, Andrew Raibeck
- Re: Select statement, John Monahan
- Re: Select statement, Hunley, Ike
- Re: Select statement, Andrew Raibeck
- Select statement, Hunley , Ike [mailto:Ike.Hunley
- Re: Select statement, John Monahan [mailto:JMonahan
- Re: Select statement, ADSM : Dist Stor Manager [mailto:ADSM-L
- Re: Select statement, Jane Bamberger [mailto:jane.bamberger
- Re: Select statement,
ADSM : Dist Stor Manager [mailto:ADSM-L <=
|
|
|