Re: sql question for purge routi

Denham.M@amstr.com wrote: : Would I be correct in assuming: : 1) You do not have a lot of activity on the database at the time you do the purge. there will be a lot of activity, but the data is very old, and shouldn't be accessed by anyone. : 2) You have very large logs to deal with the transaction (assuming the table is large). we do have lots of logs, but will be committing in batches that make sure we have no long transactions. : 3) The table itself is not being used at the time of the purge. the table will be used, but as i said, people shouldn't be accessing the records that we are deleting. if they are, someone will get an error and we will have to deal with that. it is a mess, a system that should have had a purge routine a year ago, but is no mission critical, and so big we can hardly deal with it. it isn't fun, but it is a challenge! we are most likely going to do the purge routine in 4gl, i just wasn't sure of the best syntax to deal with that kind of delete. mickm -- _____________________________________________________________________________ Mickey Mestel mickm@netcom.com -on a beach in thailand to a beautiful, stoned, norwegian woman: "..yeah, it's just another foreign country without ice." -----------------------------------------------------------------------------