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: [EMAIL PROTECTED] ************************************************************************ ****** -----Original Message----- From: ADSM: Dist Stor Manager [mailto:[EMAIL PROTECTED] On Behalf Of Joni Moyer Sent: Thursday, 05 October, 2006 15:00 To: [email protected] 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 [EMAIL PROTECTED] ********************************
