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

Good evening,

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
computer.

I have the beginning:

PROC SQL;
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 ?


Stéphane.