topic Re: Prevent %macro etls_createIndexes; in User Written Transformation (DI Studio) in SAS Data Management

Prevent %macro etls_createIndexes; in User Written Transformation (DI Studio)

strsljen — Tue, 27 Nov 2018 18:07:41 GMT

Hi,

Im am working on simple User Written Transformation which calls Oracle stored procedures with some arguments. Some are INPUT and OUTPUT tables.

But...

SAS keeps generating %macro etls_createIndexes; function and tried to call it based on metadata information for input and output tables in regards to indexes.

I really need SAS to leave them alone. Instead, SAS tries to create index that already exist and fails.

How do I prevent this macro function to be autogenerated & called?

Thanks!

Best regards,

Re: Prevent %macro etls_createIndexes; in User Written Transformation (DI Studio)

Astounding — Tue, 27 Nov 2018 18:49:23 GMT

As a short-term fix, you can add two lines to your session:

%macro etis_createindexes;

%mend etis_createindexes;

This creates a temporary version of the macro that performs no work.

Of course, it also means the original version of the macro will no longer be available for the duration of the session. So it's not a long-term cure.

Re: Prevent %macro etls_createIndexes; in User Written Transformation (DI Studio)

strsljen — Wed, 28 Nov 2018 11:10:24 GMT

Hi,

Thanks for suggestion. I would rather not do so. It might bite me back when least expected.

However, I found in Additional Options for transfotmation: Generate indexes on target tables and default is YES.

When I set it to NO, I have no issues.

I would be happiest if default option for it can be set when building User Written Transformation. Didn't find it, though.