Patrick, As per the note's 2nd point, they have disabled the automatic integrity constraints' creation. Indexes will still get created. I did observe this for the output data sets for the job. Also, we are facing issues with the SQL joins only. Table loader is working fine. I agree with you that there has to be a solution to this. Till then, I am trying this work-around to see if it works. I believe it will work as it is as good as adding the integrity constraint creation snippet to the code manually. Adding it to the post code, will keep my original job AUTOMATIC code creation intact. Will update if this work around works fine or not. But, I am sure that there are many more such surprises/issues with the SAS 9.4 version.
... View more