CODEWITHSUNDEEP
sqlviewsasvertica
Mlk
Mlk

Reputation: 91

Vertica :Creating a view

I'm trying to create a view in Vertica written in SAS.

proc sql;
      connect to odbc as try
     (server='10.10.7.174' port=5433 user=dbadmin password=password );
     execute (create view  &schema..myview as 

     ( Select * from &schema..table_1
       union all 
       Select * from &schema..table_2
     ))by try ;

 disconnect from try;
quit;

the problem is : as a result it creates a table not a view .

Upvotes: 1

Views: 318

Answers (1)

Richard
Richard

Reputation: 27508

DB views will appear as a Table type when SAS Explorer is showing the Contents of 'libname' and the libname is remote.

Upvotes: 1

Related Questions