BookmarkSubscribeRSS Feed
Loko
Barite | Level 11

Dear ALL,

 

How can I force a dbms run for an Extract Transofrmation ?

I have the input table on Oracle, the result of the extract generated in a library of type Oracle.

However the Extract seems not pushed on DBMS but rather run by SAS.

 

I have checked the Action - Check Database Processing and at the Details section it is written - Unable to completely process on Oracle.

 

At the Extract Transformation - Options - Additional Options - Use the optimized pass-through facility for SQL statements is set to Yes.

 

Any hints?

 

Thanks

1 REPLY 1
tomrvincent
Rhodochrosite | Level 12
Use explicit pass-thru rather than implicit.
How to connect to databases in SAS Viya

Need to connect to databases in SAS Viya? SAS’ David Ghan shows you two methods – via SAS/ACCESS LIBNAME and SAS Data Connector SASLIBS – in this video.

Find more tutorials on the SAS Users YouTube channel.

Discussion stats
  • 1 reply
  • 1082 views
  • 0 likes
  • 2 in conversation