topic Re: Oracle partition options for DI transformations. in SAS Data Management

Oracle partition options for DI transformations.

SoumyaD — Wed, 15 Nov 2017 08:36:36 GMT

Hi,

I am having a problem in reading/writing/updating data from oracle partition when it is done on ORACLE pass through.

Please see the attached for details.

Could someone please help me with where I am going wrong?

Thanks,

Soumya

Re: Oracle partition options for DI transformations.

JBailey — Tue, 27 Mar 2018 17:04:21 GMT

Hi @SoumyaD

When DI Studio generates explicit Pass-Through queries it filters-out SAS options targeted towards Implicit Pass-Through. The OR_PARTITION= data set option is one of these. There are some implicit pass-through options that can be passed to the database but I don't have a list of them.

So, the take away is that OR_PARTITION= only applies to SAS implicit pass-through queries.

Best wishes,

Jeff