ADSM-L

Re: Select Statement Syntax

2006-10-05 11:03:17
Subject: Re: Select Statement Syntax
From: PAC Brion Arnaud <Arnaud.Brion AT PANALPINA DOT COM>
To: ADSM-L AT VM.MARIST DOT EDU
Date: Thu, 5 Oct 2006 16:45:36 +0200
Joni,

Node_name column is wrapping because the overall length of the output is
too long : you should try to reduce it.

You where on the right track for doing this while trying to reduce the
output for backup_start/end fields.
To achieve this, try to use : 

select node_name,filespace_name,time(backup_start),time(backup_end) from
filespaces where node_name like 'NAS%' or node_name like 'SERVER%' 

However, if you're having long node names or filespaces names, you'll
still get wrapping problems ...

HTH.

Cheers.


Arnaud 

************************************************************************
******
Panalpina Management Ltd., Basle, Switzerland, 
CIT Department Viadukstrasse 42, P.O. Box 4002 Basel/CH
Phone:  +41 (61) 226 11 11, FAX: +41 (61) 226 17 01
Direct: +41 (61) 226 19 78
e-mail: arnaud.brion AT panalpina DOT com
************************************************************************
******

-----Original Message-----
From: ADSM: Dist Stor Manager [mailto:ADSM-L AT VM.MARIST DOT EDU] On Behalf Of
Joni Moyer
Sent: Thursday, 05 October, 2006 15:00
To: ADSM-L AT VM.MARIST DOT EDU
Subject: 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
********************************

<Prev in Thread] Current Thread [Next in Thread>