11-30-2016 11:06 AM
I need to specify NOIPASSTHRU on the PROC SQL code that the DIS 4.901 Extract transformation generates to prevent query from passing thru to SPDS.
Any way to do that?
12-02-2016 06:11 AM
12-02-2016 08:41 AM
SPDS still uses SQL optimizer from SAS 6.12
Some queries run much faster when processed by SAS 9.4. Mine goes from 2 minutes to 18 seconds when not passing through.
12-02-2016 07:48 AM
By default all commands are carried out in the SAS engine so you should be okay. As part of a PROC SQL statement you need to stipulate that the SQL is being passed through to the database server. e.g. below:
proc sql outobs=15;
connect to oracle as ora2 (user=user-id password=password);
select * from connection to ora2 (select lname, fname, state from staff);
disconnect from ora2;
You could try and lock this down even further by tightening how your Library connects to the DB
12-02-2016 08:45 AM
SAS passes the query down to SPDS automatically unless I specify NOIPASSTHRU (implicit pass-thru this is called).
My problem is that i can't find an option in the extract transformation that prevents the passthru.
There is a NODBIDIRECTEXECT option but this doesn't work for SPDS (i tried).
Need further help from the community? Please ask a new question.