Hi woows,
Just other 2 cents:
If your temporary table can be used by more concurrent processes (e.g. more user using the APPL/UBE on different workstations and/or citrix/wts sessions) then they can cause data collision.
The avoid this situation:
- begin all table indices with the same field, which is something NextNumber, BatchNumber, UniqueKeyID type
- before all table operation, retrieve a NextNumber/NextID, which will be unique for your session - let's name it SessionID
- use your SessionID in all temporary table operation
- after the job had been done, you can delete your "session records" whith a single key Delete Table I/O using your SessionID and based on your primary key
Hope, this helps a bit.
Regards,
Zoltán