"run q_columns TABLE" as in "run q_columns actlog" shows you all the
variables that are available in a given table. So the select you want,
without any special formatting added, is "tsm: ULTSM>Select date_time,
msgno, message, nodename from actlog Where msgno in (4952, 4954, 4957)
>>> "Lee, Gary
I want to select only a subset of messages from the activity log table.
For instance,
Select datetime, msgno, message, nodename from actlog
Where messages in (4952 4954 4957)
Etc.
Just looking for some syntax help. Don't currently have a good sql
manual.
Tia for any help.
Gary Lee
Senior Sys
Subject
.EDU> Re: select syntax
05/20/2005 01:38
PM
Please respond to
"ADSM: Dist Stor
Manager"
<[EMAIL PROTECTED]
.EDU>
Try this,
select stgpool_name as "Storage Pool",cast(est_capacity_mb/1024 as
decimal(6,0)) as "Total GB",pct_utilized as "Percent Utilized",
cast((EST_CAPACITY_MB*pct_utilized/100/1024) as decimal(15,2))
"total_data_by_GB" from stgpools where stgpool_name='NAS_TOC'
I will throw out one i use for
Sure, just add a column that multiples the two columns together
(est_capacity_mb * pct_utilized) and divide by 1024.0 to get GB, and again
by 100 (to express the pct_utilized as a fractional value):
cast(est_capacity_mb * pct_utilized / 102400.0 as decimal(6,0)) as "Used
GB"
Regards,
Andy
Andy
Hello everyone!
I run the report below to see the level of our nas toc disk pool and I was
wondering if there is a way to also have another column called GB Utilized
which multiplies total gb x percent utilized? I have tried this in so many
different ways and I have not been successful. I'm not
nager
> Sent: Monday, July 21, 2003 7:09 AM
> To: [EMAIL PROTECTED]
> Subject: Help on select syntax
>
> Hi to all
>
> Try to run a select query on the actlog table for certain msgno in certain
> period but got wrong result. Here my select command:
> select
Hi to all
Try to run a select query on the actlog table for certain msgno in certain
period but got wrong result. Here my select command:
select nodename , msgno , substr(message,44,14) as "Message"
from actlog where (msgno=4961 or msgno=4964) and date_time=CURRENT_TIMESTAMP
- 1 days
