Re: Select Statement Syntax
2006-10-05 10:49:49
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
|
|
|