David, I output info into files and then run a script to clean and parse what I don't want out of it. This is all done in one big script but the part that does it is sed..
I believe if you "sed 1,12d" this will chop the header info off and leave you with what you want.. It might be 13 instead of 12, but if you login to server and count the rows down from the login pompt you'll know what u need. Gabriel C. Wiley ADSM/TSM Administrator AIX Support Phone 1-614-308-6709 Pager 1-877-489-2867 Fax 1-614-308-6637 Cell 1-740-972-6441 Siempre Hay Esperanza |---------+----------------------------> | | David E Ehresman | | | <deehre01@LOUISVI| | | LLE.EDU> | | | Sent by: "ADSM: | | | Dist Stor | | | Manager" | | | <[EMAIL PROTECTED]| | | .EDU> | | | | | | | | | 04/24/2002 01:15 | | | PM | | | Please respond to| | | "ADSM: Dist Stor | | | Manager" | | | | |---------+----------------------------> >------------------------------------------------------------------------------------------------------------------------------| | | | To: [EMAIL PROTECTED] | | cc: | | Subject: SQL Output | | | | | >------------------------------------------------------------------------------------------------------------------------------| I there a way to get JUST the output from a select statement into a file without the TSM version header info at the beginning and the condition code at the end? This is TSM 4.2 on Aix 5.1. David