Re: Select Statement Syntax
2006-10-05 11:16:37
Joni,
Try this and see if it makes any difference, it will manipulate the
returned backup_start and backup_end to only be 16 chars and thus loose
the ".000000"
I feel sure that there is tidier way to do this, but I have yet to find
it. Suggestions gladly appreciated. In the meantime this might help.
select
node_name,filespace_name,
substr(char(backup_start),1,16) as BACKUP_START,
substr(char(backup_end),1,16) as BACKUP_END
from filespaces where node_name like 'NAS%' or node_name like 'SERVER%'
Thanks
Leigh
-----Original Message-----
From: ADSM: Dist Stor Manager [mailto:ADSM-L AT VM.MARIST DOT EDU] On Behalf Of
Joni Moyer
Sent: 05 October 2006 14:00
To: ADSM-L AT VM.MARIST DOT EDU
Subject: [SPAM: 4.000] [ADSM-L] Select Statement Syntax
Hello Everyone,
I have been trying to figure out how to have the syntax of the below
output so that it will all go on 1 line, but so far I have been very
unsuccessful.
Here is the statement I am issuing:
select node_name,filespace_name,backup_start,backup_end from filespaces
where node_name like 'NAS%' or node_name like 'SERVER%'
And here is the output:
NODE_NAME FILESPACE_NAME BACKUP_START
BACKUP_END
------------------ ------------------ ------------------
------------------
NAS_SERVER_2_OFFS- / 2006-10-04
2006-10-04
ITE 21:20:32.000000
21:23:03.000000
NAS_SERVER_2_OFFS- /.etc_common 2006-10-04
2006-10-05
ITE 21:20:32.000000
02:34:44.000000
NAS_SERVER_2_OFFS- /apache 2006-10-04
2006-10-05
ITE 21:20:32.000000
02:21:08.000000
NAS_SERVER_2_OFFS- /clearcase_prod 2006-10-04
2006-10-04
ITE 21:20:32.000000
22:36:12.000000
As you can see the node_name column wraps. I tried to do a left justify
and I also tried to make it 20 characters wide, but I guess I am doing
something wrong because I continue to get the same output.
I was also wondering if there is a way to change the backup_start to go
on
1 line as well and to make it include the date and the time to be just
hh:mm:ss?
Thank you in advance for any pointers you might have!
********************************
Joni Moyer
Highmark
Storage Systems, Senior Systems Programmer
Phone Number: (717)302-9966
Fax: (717) 302-9826
joni.moyer AT highmark DOT com
********************************
|
|
|