ADSM-L

Re: Select Statement Syntax

2006-10-05 10:49:49
Subject: Re: Select Statement Syntax
From: Jonathan Siegle <jsiegle AT PSU DOT EDU>
To: ADSM-L AT VM.MARIST DOT EDU
Date: Thu, 5 Oct 2006 10:38:11 -0400
Joni Moyer said the following on 10/5/06 9:00 AM:
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.


Hi Joni,
        Try doing "set sqldisplaymode wide" before you run your select
statement. That should put each column in your select statement on one
line. You could also try using -tabd when you call dsmadmc and then also
"set sqldisplaymode wide" once the admin session has started. That might
 give you the whole ball of wax on one line.

-Jonathan

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