Query_timeout in connection Proc sql

[sabya_biswal]

Hi ,

Can you please help on how to use query_timeout /timeout option in connection part of proc sql in SAS.

I am specifically looking for Oracle connection, and the purpose is to abort the query execution when it reaches the timeout threshold.

[ChrisNZ]

> abort the query execution when it reaches the timeout threshold.

I don't think such an option exists on the SAS side. It's usually the Oracle DBAs who set these kinds of limits

[ChrisNZ]

Actually, the SAS documentation doesn't mention Oracle or ODBC, but ODBC seems to support that option.

See page 19 of http://www.math.wpi.edu/saspdf/accodbc/c01.pdf

When things get cloudy like that. a call to tech support to ask them to answer the question, and to clarify the documentation is often the best option.

What to you get when you try?

[SASKiwi]

@sabya_biswal  - Please post the SAS log including the error you are getting.