Re: Creating lis file ONLY if necessary - How?
From: Gary Myers <101355.3556_at_CompuServe.COM>
Date: 1995/12/02
Message-ID: <49qass$rjl$1_at_mhadg.production.compuserve.com>#1/1
Date: 1995/12/02
Message-ID: <49qass$rjl$1_at_mhadg.production.compuserve.com>#1/1
How about deleteing the file afterwards if no rows were returned ? Column NEW_VALUE can be used to determine if any rows were returned. Select 'HOST DELETE...' from Dual into a spool file if the value has not been altered.
Gary
-- Gary Myers, Analyst/Programmer, Kaisha Technology, West of EnglandReceived on Sat Dec 02 1995 - 00:00:00 CET