Hi ,
In my DB table there are invalid user details getting inserted from a particular source system A, when it is inserted from that source system a particular column USER_METHOD is stored as null in the DB table for every entry inserted from the source system A, but that column is linked to a mandatory field in our system B, hence it cant be null.
Now i need a preventive mechanism to come up with a CHECK constraint which will check the USER_METHOD is null , if it is null then it should not insert the complete entry/row for that table which holds 10 columns, if the USER_METHOD is not null then it should allow the insert of the complete record/row.We are checking with that source system A on what can be done for it as a first step we need to have a preventive measures in place to not support any insertion from Source System A by checking the USER_METHOD column is null or not.
Please let me know how we can make this change? any examples will be helpful.
Thanks