Re: Checking for dupe key on WRITE

[Simon Coulter <shc@xxxxxxxxxxxxxxxxx>]

On 10/01/2008, at 9:20 AM, Bradley V. Stone wrote:

> In a worst case scenario, yes.  But that doesn't mean you should  
> only use
> the duplicate key error and NOT check for existance before blindly  
> writing a
> record.

That rather depends on the expected outcome. If you EXPECT duplicates  
to exist most of the time then it makes sense to check beforehand. If  
you EXPECT no duplicates then it is "better" to write the record and  
catch any exception.


Regards,
Simon Coulter.
--------------------------------------------------------------------
   FlyByNight Software         OS/400, i5/OS Technical Specialists

   http://www.flybynight.com.au/
   Phone: +61 2 6657 8251   Mobile: +61 0411 091 400        /"\
   Fax:   +61 2 6657 8251                                   \ /
                                                             X
                 ASCII Ribbon campaign against HTML E-Mail  / \
--------------------------------------------------------------------