I have 2 datastage jobs that insert in a single table. One job requires 4 columns as NOT NULL to get a unique record, while the other job needs only 2 columns of the same 4 column set to get an unique record. I cannot pass any default values in the 2nd job for the 2 columns for which I am not getting data. Can any one suggest a solution without altering the Database Not Null constraint settings.
Thanks,
Nilotpal.
Handling Primary Key conflict
Moderators: chulett, rschirm, roy