Running SQL in Teradata - Replace View statement

[Marcus_Peters]

Hi everyone

I've got some code written in SAS EG to connect to Teradata using PROC SQL and then execute a query via SQL Pass-Through. I am trying to make Teradata run a Replace View statement, and although I don't get an error in the SAS log my code is not executing! I have tested this by amending the view directly in Teradata and then re-running my SAS code (which should reverse the changes I made in Teradata), but it doesn't run.

If anyone has any suggestions I would be grateful - this is really bugging me!

Thanks

Marcus

[AhmedAl_Attar]

Check this paper for some clues

https://www.lexjansen.com/pharmasug/2017/BB/PharmaSUG-2017-BB17.pdf

use this SAS option

OPTIONS DEBUG=DBMS_SELECT SASTRACE=',,,d' SASTRACELOC=SASLOG NOSTSUFFIX;

Make sure your SAS connection credentials are identical to the credentials you used when you logged into Teradata outside of SAS.  

Hope this hellps,

Ahmed

[Tom]

Are you saying you ran a REPLACE VIEW .... statement and the view was not replaced (or created if it wasn't there).

Are you sure you are defining the view in the same place with both methods?