Try the following setting:
Set sqldisplaymode wide
_____________________________
Ian Smith
SAN/TSM Specialist
-----Original Message-----
From: ADSM: Dist Stor Manager [mailto:ADSM-L AT VM.MARIST DOT EDU] On Behalf Of
Joni Moyer
Sent: 04 October 2006 13:27
To: ADSM-L AT VM.MARIST DOT EDU
Subject: [ADSM-L] Spacing for a select statement
Hello everyone,
I was just wondering if you would happen to know how I might be able to
fit all of the output on one line for the below select statement? Any
suggestions are appreciated. Thanks!
select node_name,filespace_name,backup_start,backup_end from filespaces
where node_name like 'NAS%' or node_name like 'SERVER%'
NODE_NAME FILESPACE_NAME BACKUP_START
BACKUP_END
------------------ ------------------ ------------------
------------------
NAS_SERVER_4_OFFS- /.etc_common 2006-10-03
2006-10-03
ITE 20:57:05.000000
20:59:52.000000
NAS_SERVER_4_OFFS- /home4 2006-10-03
2006-10-03
ITE 20:57:05.000000
22:01:03.000000
NAS_SERVER_4_OFFS- /home4/home4dir1 2006-10-03
2006-10-03
ITE 20:57:05.000000
22:24:09.000000
NAS_SERVER_4_OFFS- /home4/home4dir2 2006-10-03
2006-10-04
ITE 20:57:05.000000
01:39:44.000000
NAS_SERVER_4_OFFS- /issue 2006-08-02
2006-08-03
********************************
Joni Moyer
Highmark
Storage Systems, Senior Systems Programmer Phone Number: (717)302-9966
Fax: (717) 302-9826
joni.moyer AT highmark DOT com
********************************
_____________________________________________________________
This email (including any attachments to it) is confidential, legally
privileged, subject to copyright and is sent for the personal attention of the
intended recipient only. If you have received this email in error, please
advise us immediately and delete it. You are notified that disclosing, copying,
distributing or taking any action in reliance on the contents of this
information is strictly prohibited. Although we have taken reasonable
precautions to ensure no viruses are present in this email, we cannot accept
responsibility for any loss or damage arising from the viruses in this email or
attachments. We exclude any liability for the content of this email, or for the
consequences of any actions taken on the basis of the information provided in
this email or its attachments, unless that information is subsequently
confirmed in writing. If this email contains an offer, that should be
considered as an invitation to treat.
_____________________________________________________________
|