LISTSERV at the University of Georgia
Menubar Imagemap
Home Browse Manage Request Manuals Register
Previous messageNext messagePrevious in topicNext in topicPrevious by same authorNext by same authorPrevious page (January 2005, week 4)Back to main SAS-L pageJoin or leave SAS-L (or change settings)ReplyPost a new messageSearchProportional fontNon-proportional font
Date:         Thu, 27 Jan 2005 19:57:32 +0000
Reply-To:     datametric@CLUB-INTERNET.FR
Sender:       "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>
From:         SUBSCRIBE SAS-L Stephane <datametric@CLUB-INTERNET.FR>
Subject:      Re: Remote execution needed
Comments: To: harry.droogendyk@RBC.COM
Content-Type: text/plain; charset=ISO-8859-1

right but SAS it's so fantastic and unforeseeable :-)

I think we can do this, but the temporary pool must be in the same schema (database). Otherwise, the data must be forwarded to the SAS server application, apparently .

I prefer to stay in SAS for loading data, but you're true about using the teradata queries tool. I stay to add SAS statement when I load the table.

Stéphane.

----Message d'origine---- >Date: Thu, 27 Jan 2005 13:45:10 -0500 >De: Harry Droogendyk <harry.droogendyk@RBC.COM> >Sujet: Re: Remote execution needed >A: SAS-L@LISTSERV.UGA.EDU > >One never knows. SAS --might-- be smart and realize it's Teradata to Teradata.... But I wouldn't count on it. > >Do you have something like Queryman / BI Query to do this type of thing directly without involving SAS? > >-----Original Message----- >From: datametric@club-internet.fr [mailto:datametric@club-internet.fr] >Sent: Thursday, January 27, 2005 2:39 PM >To: Droogendyk, Harry >Cc: SAS-L@LISTSERV.UGA.EDU >Subject: Re: Re: Remote execution needed > > >Ok, I'll try the second step. > >In the first step, the definition of the libname disturbs me, because it is a RLS. Will the data forward by my PC ? yes I think. > >Stéphane. > >----Message d'origine---- >>Date: Thu, 27 Jan 2005 12:14:46 -0500 >>De: Harry Droogendyk <harry.droogendyk@RBC.COM> >>Sujet: Re: Remote execution needed >>A: SAS-L@LISTSERV.UGA.EDU >> >>Or ( untested ), I THINK you can simply qualify the Teradata table name with the schema name. However, it may have to be a three level name, e.g. database.schema.table. >> >> >>PROC SQL; >> connect to teradata as vm (user="&_user" pass="&_pass" schema="&_schema2"); >> execute (CREATE TABLE zztemp as >> select distinct id_ucmkt_pe >> from &_schema1..decocntc ) by vm; >> disconnect from vm; >>quit; >> >>-----Original Message----- >>From: Droogendyk, Harry >>Sent: Thursday, January 27, 2005 12:10 PM >>To: SAS-L (E-mail) >>Subject: RE: Remote execution needed >> >> >> >>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. >> >>============================================================ >> >> > > > >------------------------------------------------------------ > >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. > >============================================================ > >


Back to: Top of message | Previous page | Main SAS-L page