Hey! I am trying to put together a select statement to find all archives for CS-NICE-STORAGE, but it is showing me the output in the below format. Is there a way that I can get all of the info. on 1 line and also make the archive_date split into date & time? Thanks in advance!
Here is the command I was running: select node_name,filespace_name,hl_name || ll_name as "File",archive_date,class_name from archives where node_name='CS-NICE-STORAGE' NODE_NAME: CS-NICE-STORAGE FILESPACE_NAME: \\cs-nice-storage\c$ File: \COMPAQ ARCHIVE_DATE: 1900-01-01 00:00:00.000000 CLASS_NAME: DEFAULT NODE_NAME: CS-NICE-STORAGE FILESPACE_NAME: \\cs-nice-storage\c$ File: \COMPAQ ARCHIVE_DATE: 1900-01-01 00:00:00.000000 CLASS_NAME: DEFAULT NODE_NAME: CS-NICE-STORAGE FILESPACE_NAME: \\cs-nice-storage\c$ File: \COMPAQ ARCHIVE_DATE: 1900-01-01 00:00:00.000000 CLASS_NAME: DEFAULT NODE_NAME: CS-NICE-STORAGE FILESPACE_NAME: \\cs-nice-storage\c$ File: \COMPAQ ARCHIVE_DATE: 1900-01-01 00:00:00.000000 CLASS_NAME: DEFAULT ******************************** Joni Moyer Highmark Storage Systems Work:(717)302-6603 Fax:(717)302-5974 [EMAIL PROTECTED] ********************************