topic Re: Running SQL in Teradata - Replace View statement in SAS Programming

Running SQL in Teradata - Replace View statement

Marcus_Peters — Fri, 26 Jun 2020 14:54:44 GMT

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

Re: Running SQL in Teradata - Replace View statement

AhmedAl_Attar — Fri, 26 Jun 2020 18:03:55 GMT

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

Re: Running SQL in Teradata - Replace View statement

Tom — Fri, 26 Jun 2020 18:07:40 GMT

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?