Provide the ability to determine if the implicit Pass-Through statements will be passed to the DBMS or executed in SAS before the code is actually submitted
Doesn't the noexec clause already do this?
My understanding of NOEXEC is completely different. SAS Help defines NOEXEC as follows:
NOEXEC is useful if you want to check the syntax of your SQL statements without executing the statements.
What we're voting for here is to send the query to the remote computer verbatim – without any modifications. This is very useful for those people who know that remote computer better than SAS knows the remote computer. SAS is pretty good at helping novice users translate such things, but experienced users would like an option to decline such help.
A problem is that if you use the Pass-Through you have to write the code in in DB language and you, for example, can't use the SAS function.
There are Oracle function that don't exist in SAS.
It's difficult to implement this difference.
If you write code is a thing if you use Data Integration is different.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.