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
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
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: [EMAIL PROTECTED]
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:[EMAIL PROTECTED]]
Sent: Friday, February 15, 2002 4:36 PM
To: [EMAIL PROTECTED]
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
