Yes, the cast doesn't handle this, but padding the heading with blanks
(see my note below) should do the trick.
Also see my note below about the -DISPLAYMODE option. -DISPLAYMODE=LIST
will "force" the output to the "list-style" format as your output shows.
If you prefer tabular output (one record per line), you can use
-DISPLAYMODE=TABLE.
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.
"Hunley, Ike" <[EMAIL PROTECTED]>
Sent by: "ADSM: Dist Stor Manager" <[EMAIL PROTECTED]>
02/19/2002 05:43
Please respond to "ADSM: Dist Stor Manager"
To: [EMAIL PROTECTED]
cc:
Subject: Re: Select statement
I tried that. filespace_name still wrapped. I selected enough fields so
that the output looks like this...
NODE: HOC08F5001
SPACE_MB: 704.00
PCT_USED: 91.20
FILESPACE: /export/AIX433_ML
BACKUP_START: 2000-10-03 00:25:39.000000
BACKUP_END: 2000-10-03 00:25:46.000000
I xfer this data to OS/390 and using REXX, I create the report I want.
-----Original Message-----
From: John Monahan [mailto:[EMAIL PROTECTED]]
Sent: Monday, February 18, 2002 6:12 PM
To: [EMAIL PROTECTED]
Subject: Re: Select statement
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 <[EMAIL PROTECTED]>
Sent by: "ADSM: Dist Stor Manager" <[EMAIL PROTECTED]>
02/16/2002 07:11 AM
Please respond to "ADSM: Dist Stor Manager"
To: [EMAIL PROTECTED]
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
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
Blue Cross Blue Shield of Florida, Inc., and its subsidiary and
affiliate companies are not responsible for errors or omissions in this
e-mail message. Any personal comments made in this e-mail do not reflect
the views of Blue Cross Blue Shield of Florida, Inc.
