https://communities.sas.com/t5/SAS-Enterprise-Guide/unable-to-access-Oracle-table-using-surrogate-key-gen-transform/m-p/71453#M7117 In my job I m using a surrogate key generator transform for which the target table is an oracle table. Whenever I close the job and reopen it and run it, the job is not able to find the target oracle table…<BR /> Here is the snap from the log<BR /> <BR /> SYMBOLGEN: Macro variable TARGETTABLE resolves to ORADIM.DIM_CASE_STATUS<BR /> SYMBOLGEN: Some characters in the above value which were subject to macro quoting have been unquoted for printing.<BR /> MLOGIC(CREATESURROGATEKEY): %IF condition (%sysfunc(exist(&amp;targetTable)) eq 1) is FALSE<BR /> <BR /> However, when I run job for the second time(ie without closing it) then it is working fine…<BR /> Can u pls help me with this? Wed, 28 Jan 2009 13:18:54 GMT deleted_user 2009-01-28T13:18:54Z https://communities.sas.com/t5/SAS-Enterprise-Guide/unable-to-access-Oracle-table-using-surrogate-key-gen-transform/m-p/71453#M7117 In my job I m using a surrogate key generator transform for which the target table is an oracle table. Whenever I close the job and reopen it and run it, the job is not able to find the target oracle table…<BR /> Here is the snap from the log<BR /> <BR /> SYMBOLGEN: Macro variable TARGETTABLE resolves to ORADIM.DIM_CASE_STATUS<BR /> SYMBOLGEN: Some characters in the above value which were subject to macro quoting have been unquoted for printing.<BR /> MLOGIC(CREATESURROGATEKEY): %IF condition (%sysfunc(exist(&amp;targetTable)) eq 1) is FALSE<BR /> <BR /> However, when I run job for the second time(ie without closing it) then it is working fine…<BR /> Can u pls help me with this? Wed, 28 Jan 2009 13:18:54 GMT https://communities.sas.com/t5/SAS-Enterprise-Guide/unable-to-access-Oracle-table-using-surrogate-key-gen-transform/m-p/71453#M7117 deleted_user 2009-01-28T13:18:54Z https://communities.sas.com/t5/SAS-Enterprise-Guide/unable-to-access-Oracle-table-using-surrogate-key-gen-transform/m-p/71454#M7118 I think SAS support will the proper way to solve this issue.<BR /> <BR /> /Linus Wed, 28 Jan 2009 14:26:49 GMT https://communities.sas.com/t5/SAS-Enterprise-Guide/unable-to-access-Oracle-table-using-surrogate-key-gen-transform/m-p/71454#M7118 LinusH 2009-01-28T14:26:49Z