I am generating a set of records in a table called PRODUCTS, using a looping script, based on records in a table called SIZES. The records created would be of the form;
What changes do I need to make so a record is not created (duplicate record), if the record already exists in the PRODUCTS table.
If DM12013-2 already exists I do not want to create a second copy of it. I would not want an error message, but the script to just go ahead and create the remaining records for the PRODUCTS table.