My requirement is:
I need to insert records into one table A.Before inserting it should check the newly inserting records already there in table A.If it is there it should stop insert and it should go to other insert statement.
we will insert records into table from anywhere like java...
But the duplicates checking and insert stopping should happen inside DB2 trigger.
Can you please tell me possible solution for this?
I need to insert records into one table A.Before inserting it should check the newly inserting records already there in table A.If it is there it should stop insert and it should go to other insert statement.
we will insert records into table from anywhere like java...
But the duplicates checking and insert stopping should happen inside DB2 trigger.
Can you please tell me possible solution for this?
Comment