Ryan Farrell wrote: > We're using DB2 for Solaris. We have tried using , but that doesn't > work for some reason.
In combination with what? If you do it in combination with something to SELECT MAX(id) from your table it indeed won't work. What you are trying to prevent is a phantom read, which requires a isolation level of serializable. If you are trying some built-in functionality, show us the code. Jochem ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Archives: http://www.houseoffusion.com/cf_lists/index.cfm?forumid=4 Subscription: http://www.houseoffusion.com/index.cfm?sidebar=lists&body=lists/cf_talk FAQ: http://www.thenetprofits.co.uk/coldfusion/faq Structure your ColdFusion code with Fusebox. Get the official book at http://www.fusionauthority.com/bkinfo.cfm