When I add a constraint to the source for a CREATE TABLE I am getting errors that the previous constraints already exists.
Also I was able to compile a table with a constraint but was unable to promote the table because the reference table was not in the staging schema/library.
I get a FILE not Found in IMAY04.
Can you please contact PTC Implementer Support or log a case online? We're going to need your SCN, version of Implementer and list of patches installed. Unfortunately, this is not a simple answer without gathering additional information.
Implementer Support Manager
I am not sure about the SCN, I am running a currently updated
Version . . . : 10.3
Is there a suggested process for handling SQL Tables with Constraints?
I am still learning how to use Implementer, but SQL tables and associated tasks are brand new for my current company and we have no working examples.
I have currently been able to create and promote Tables and views, but the addition of constraints is causing me headaches.