I have a z-program that adds new records to a z-table every one minute.What we need to do is that we need to fetch the records from the z-table and for every record a testing is done and finally it will be deleted from the table. I dont understand how we need to fetch from this populating table? I mean, do we need to lock the record first and then fetch it, do processing and then finally delete it? Do we actually require locking the records??? how do we read the table when it gets new records every one minute??
can anyone send me pseudo code for this?? pls give me suggestions.
Thanks for all..
I shall def reward all helpful answers.