Date: Thu, 27 Jan 2005 12:01:39 -0500
Reply-To: SUBSCRIBE SAS-L Stephane <datametric@CLUB-INTERNET.FR>
Sender: "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>
From: SUBSCRIBE SAS-L Stephane <datametric@CLUB-INTERNET.FR>
Subject: Remote execution needed
Content-Type: text/plain; charset=ISO-8859-1
Today, I have only one Teradata srv and my poor station (only sas access to
teradata on my desktop and no SAS server side on teradata,if you like).
I’d like to write a table from schema named A towards the temporary pool
teradata which is in another schema named B. I want to the execution is
done on the machine teradata and avoid making forward the data on my
I have the beginning:
connect to teradata as mep (user="&_user" pass="&_pass" schema="&_schema1");
connect to teradata as vm (user="&_user" pass="&_pass" schema="&_schema2");
and I will like the continuation. It should resemble to :
execute (CREATE TABLE zztemp as
(select * from connection to mep (select distinct id_ucmkt_pe from
decocntc))) by vm;
I think it’s not the good syntax, SAS and teradata don’t understand
anything. the error should not correspond to the real problem, but I copy
it nevertheless :
ERROR: Teradata execute: Syntax error, expected something like an 'EXCEPT'
keyword or an 'UNION' keyword or a 'MINUS' keyword or ')' between the
word 'connection' and the 'to' keyword.
Have you an idea ?