Please answer if there is a way to keep connection alive between multiple proc sql's?
connect to teradata as tera (user=testuser pass=testpass);
and then just use this connection in other proc sql's:
execute (drop table salary) by tera;
execute (commit) by tera;
execute (create table salary (current_salary float, name char(10)))
disconnect from tera;