Looked in the db2 manuals, didn't see what I wanted.
Tsm 6.2.5 under RHEL 6.1
Is there a way to trim trailing whitespace from string fields within a select
statement?
Looked at the trim function, but it didn't appear to be what I needed.
Thanks for the help.
Have you looked at rtrim?
-
Cameron Hanover
chano...@umich.edu
Our integrity sells for so little, but it is all we really have. It is the
very last inch of us, but within that inch, we are free.
--Valerie (V for Vendetta)
On Oct 2, 2014, at 10:29 AM, Lee, Gary g...@bsu.edu wrote:
Looked in
On Mon, 2 Jun 2008 14:58:06 -0400, Richard Rhodes [EMAIL PROTECTED] said:
I am thinking that you'll need to just get the raw columnar data for each
volume record, then feed it into another program
That's what I was beginning to think, and where I'll head.
Permit me to recommend 'sqlite'.
:To
Dist Stor ADSM-L@VM.MARIST.EDU
Manager cc
[EMAIL PROTECTED]
.EDU Subject
Re: yasq (yet another SQL question
I'm trying to get a handle around the compression ratio on our
3494 tapes. I'm trying to generate a table showing each
compression ratio and the number of volumes of that ratio.
All the tapes in the lib are 60gb. It should look simething
like this . . .
ratio count
- -
The problem is that unless est_capacity_mb matches exactly between
multiple volumes, the results of the from will return a single record
from the VOLUMES table consisting of the est_capacity_mb field and the
count (which is 1). After the math is done on the column to compute the
ratio, you have
Try without distinct
Goodl luck
-Original Message-
From: ADSM: Dist Stor Manager [mailto:[EMAIL PROTECTED] On Behalf Of
Richard Rhodes
Sent: Monday, June 02, 2008 2:09 PM
To: ADSM-L@VM.MARIST.EDU
Subject: [ADSM-L] yasq (yet another SQL question)
I'm trying to get a handle around
I am thinking that you'll need to just get the raw columnar data for each
volume record, then feed it into another program
That's what I was beginning to think, and where I'll head.
Thanks!
Rick
-
The information contained in this message is intended
Clarification:
The first (long) sentence of my earlier response(below) should read:
The problem is that unless est_capacity_mb matches exactly between
multiple volumes, the results of the from will return a single record
from the VOLUMES table ***for each volume*** consisting of the
like 'NASPOOL_L4' group by est_capacity_mb
,volume_name
-Original Message-
From: ADSM: Dist Stor Manager [mailto:[EMAIL PROTECTED] On Behalf Of
Andrew Raibeck
Sent: Monday, June 02, 2008 2:43 PM
To: ADSM-L@VM.MARIST.EDU
Subject: Re: [ADSM-L] yasq (yet another SQL question)
The problem
Re: yasq (yet another sql question
. . . . )
01/19/2005 03:19
AM
Please respond to
ADSM: Dist Stor
Manager
Hi.
Think the problem is in TSM!
Se my examples:
FIRST I run
Hi Everyone . . .
I'm trying to do a couple things . . . .
1) Trying to get a listing as follows, where the occupancy filespace
stats are sum'ed for each node, with the node domain thrown in:
like this: node domain sum-files sum-physicalMB sum-logicalMB
Here is the command I'm trying
Well, if you connected to TSM via ACCESS, it would look like this:
SELECT DISTINCTROW OCCUPANCY.STGPOOL_NAME, Sum(OCCUPANCY.NUM_FILES) AS
[Sum Of NUM_FILES], Sum(OCCUPANCY.PHYSICAL_MB) AS [Sum Of PHYSICAL_MB],
Sum(OCCUPANCY.LOGICAL_MB) AS [Sum Of LOGICAL_MB], Count(*) AS [Count Of
OCCUPANCY] FROM
:[EMAIL PROTECTED] On Behalf Of
Richard Rhodes
Sent: Tuesday, January 18, 2005 11:35 AM
To: ADSM-L@VM.MARIST.EDU
Subject: yasq (yet another sql question . . . . )
Hi Everyone . . .
I'm trying to do a couple things . . . .
1) Trying to get a listing as follows, where the occupancy filespace
.
Prather, Wanda
[EMAIL PROTECTED]To: ADSM-L@VM.MARIST.EDU
HUAPL.EDU cc: (bcc: Eivind Birkeland)
Sent by: ADSM: Subject: Re: yasq (yet another
sql question . . . . )
Dist Stor
15 matches
Mail list logo