Use: select node_name as "NODE_NAME ", filespace_name as "FILESPACE_NAME ", ...
padding the quoted titles with enough blank spaces to achieve what you want. Alternatively, consider using a Windows spreadsheet or database program to access the TSM Server via ODBC driver, which can give you an opportunity customize the presentation of the data. Andy Raibeck IBM Software Group Tivoli Storage Manager Client Development Internal Notes e-mail: Andrew Raibeck/Tucson/[EMAIL PROTECTED] Internet e-mail: [EMAIL PROTECTED] IBM Tivoli Storage Manager support web page: http://www.ibm.com/software/sysmgmt/products/support/IBMTivoliStorageManager.html The only dumb question is the one that goes unasked. The command line is your friend. "Good enough" is the enemy of excellence. "ADSM: Dist Stor Manager" <ADSM-L@VM.MARIST.EDU> wrote on 10/05/2006 06:00:04 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. > > 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] > ********************************