Desktop productivity for business analysts and programmers

unable to access Oracle table using surrogate key gen transform ,first time

Reply
N/A
Posts: 0

unable to access Oracle table using surrogate key gen transform ,first time

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…
Here is the snap from the log

SYMBOLGEN: Macro variable TARGETTABLE resolves to ORADIM.DIM_CASE_STATUS
SYMBOLGEN: Some characters in the above value which were subject to macro quoting have been unquoted for printing.
MLOGIC(CREATESURROGATEKEY): %IF condition (%sysfunc(exist(&targetTable)) eq 1) is FALSE

However, when I run job for the second time(ie without closing it) then it is working fine…
Can u pls help me with this?
Esteemed Advisor
Posts: 5,198

Re: unable to access Oracle table using surrogate key gen transform ,first time

I think SAS support will the proper way to solve this issue.

/Linus
Data never sleeps
Ask a Question
Discussion stats
  • 1 reply
  • 90 views
  • 0 likes
  • 2 in conversation