How to handle serach and insert a table at the same time?
Posted: Tue Sep 21, 2004 1:53 pm
Hi there,
A job needs to insert a record into a table. before inserting, the table is searched to see if the record is already in the table. If it is, brings back its primary key. The Database is DB2 7.2.9. When the job is run, it hangs up. How can the transaction be set to allow the search and insert a table at the same time?
Thanks every body,
A job needs to insert a record into a table. before inserting, the table is searched to see if the record is already in the table. If it is, brings back its primary key. The Database is DB2 7.2.9. When the job is run, it hangs up. How can the transaction be set to allow the search and insert a table at the same time?
Thanks every body,