Stéphane:

The "(select * from connection to mep" stuff is SAS code attempting to make use of the SAS/Access connection to MEP. However, you have it inside the EXECUTE statement, which is "passed through" to Teradata.

Off the top of my head, the simpliest way to solve this might be to assign a Teradata libname to the VM connection and use pass-thru to pull the data from MEP and write to VM.

e.g.

libname vm teradata user='blah' pass='blah' schema="&schema2";

PROC SQL; connect to teradata (user="&_user" pass="&_pass" schema="&_schema1");

CREATE TABLE vm.zztemp as select * from connection to teradata ( select distinct id_ucmkt_pe from decocntc ) ; disconnect from teradata; quit;

-----Original Message----- From: SAS(r) Discussion [mailto:SAS-L@LISTSERV.UGA.EDU]On Behalf Of SUBSCRIBE SAS-L Stephane Sent: Thursday, January 27, 2005 12:02 PM To: SAS-L@LISTSERV.UGA.EDU Subject: Remote execution needed

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.

------------------------------------------------------------

This e-mail may be privileged and/or confidential, and the sender does not waive any related rights and obligations. Any distribution, use or copying of this e-mail or the information it contains by other than an intended recipient is unauthorized. If you received this e-mail in error, please advise me (by return e-mail or otherwise) immediately.

Ce courrier électronique est confidentiel et protégé. L'expéditeur ne renonce pas aux droits et obligations qui s'y rapportent. Toute diffusion, utilisation ou copie de ce message ou des renseignements qu'il contient par une personne autre que le (les) destinataire(s) désigné(s) est interdite. Si vous recevez ce courrier électronique par erreur, veuillez m'en aviser immédiatement, par retour de courrier électronique ou par un autre moyen.

============================================================