Is there a way to modify the following select statement so that a status of 'Failed' is displayed as a status of 'Incomplete' --preserving the display of 'Missed' as 'Missed' ?
tsm: TSMBL01>select node_name,status from events where (status='Missed') or (status='Failed' and result=12) NODE_NAME STATUS ------------------ ---------- I135 Missed JTRAIN3 Failed BL-CHEM-ISO Missed Thank you, Keith Arbogast
