[prev in list] [next in list] [prev in thread] [next in thread]
List: sas-l
Subject: Re: can sas processing levarage of teradata
From: "Kirby, Ted" <ted.kirby () LEWIN ! COM>
Date: 2016-01-26 17:01:40
Message-ID: 605395e00b2440a192d88fd726c720a0 () USFCH-EX2013B ! lewin ! com
[Download RAW message or body]
[Attachment #2 (text/plain)]
Are you saying you want to use SAS ® to execute Teradata ® commands on Oracle ® data? \
I know next to nothing about either Teradata ® or Oracle ®, but to me this sounds \
like an impossible request. When I searched Lex Jansen's site I found a paper seems \
to give SAS ® equivalents of Teradata ® queries. (I only skimmed the paper). I \
think that would be the only thing you can do to get what you want (if my \
understanding of your question is accurate). The paper in question is "Teradata ® \
for the SAS ® Programmer: Ordered Analytical Functions, Hash Objects, ANSI SQL: 2003 \
(19-2011)."
From: SAS(r) Discussion [mailto:SAS-L@LISTSERV.UGA.EDU] On Behalf Of Baba s
Sent: Tuesday, January 26, 2016 11:05 AM
To: SAS-L@LISTSERV.UGA.EDU
Subject: Re: can sas processing levarage of teradata
Hi,
There is data in oracle,i wanted to know can SAS processing leverage of Teradata. \
Here there is no data in Teradata. Please let me know what is the process to running \
query to read oracle data with sas and teradata.
Regards,
Baba.
On Tue, Jan 26, 2016 at 9:25 AM, Nat Wooding \
<nathani@verizon.net<mailto:nathani@verizon.net>> wrote: Baba
I have never worked with Teradata but hopefully someone else on the list
will comment. You call always contact SAS Tech. Support.
Nat
-----Original Message-----
From: SAS(r) Discussion \
[mailto:SAS-L@LISTSERV.UGA.EDU<mailto:SAS-L@LISTSERV.UGA.EDU>] On \
Behalf Of Baba s
Sent: Tuesday, January 26, 2016 8:58 AM
To: SAS-L@LISTSERV.UGA.EDU<mailto:SAS-L@LISTSERV.UGA.EDU>
Subject: Re: can sas processing levarage of teradata
Hi Nat,Thank you replying.i want to know how to optimize data loading using
Sas and teradata.As per my knowledge 1.for base Sas:need to have Sas access
Interface to teradata 2.For Di studio:there is teradata loader under
access.these two are options are useful to processing leverage of teradata.i
have researched many articles in the above link(which you provided in the
previous email) I did not find any useful info.coild you please help me
above two points are correct.Regards,Baba.
Sent from my iPhone
> On Jan 25, 2016, at 9:00 PM, Nat Wooding \
> <nathani@VERIZON.NET<mailto:nathani@VERIZON.NET>> wrote:
> If you go to Lex Jansen's site and search for Teradata, you will find a
number of papers from SAS Institute as well as papers presented at user's
group meetings.
>
> Nat Wooding
>
> http://www.lexjansen.com/search/searchresults.php
>
>
>
> -----Original Message-----
> From: SAS(r) Discussion \
> [mailto:SAS-L@LISTSERV.UGA.EDU<mailto:SAS-L@LISTSERV.UGA.EDU>] On Behalf Of Baba s
> Sent: Monday, January 25, 2016 8:46 PM
> To: SAS-L@LISTSERV.UGA.EDU<mailto:SAS-L@LISTSERV.UGA.EDU>
> Subject: can sas processing levarage of teradata
>
> Hi,
>
> Please let me know can sas processing levarage of teradata.
>
> Regards,
> Baba.
>
************* IMPORTANT - PLEASE READ ********************
This e-mail, including attachments, may include confidential and/or proprietary \
information, and may be used only by the person or entity to which it is addressed. \
If the reader of this e-mail is not the intended recipient or his or her authorized \
agent, the reader is hereby notified that any dissemination, distribution or copying \
of this e-mail is prohibited. If you have received this e-mail in error, please \
notify the sender by replying to this message and delete this e-mail immediately.
[Attachment #3 (text/html)]
<html xmlns:v="urn:schemas-microsoft-com:vml" \
xmlns:o="urn:schemas-microsoft-com:office:office" \
xmlns:w="urn:schemas-microsoft-com:office:word" \
xmlns:m="http://schemas.microsoft.com/office/2004/12/omml" \
xmlns="http://www.w3.org/TR/REC-html40"> <head>
<meta http-equiv="Content-Type" content="text/html; charset=utf-8">
<meta name="Generator" content="Microsoft Word 14 (filtered medium)">
<style><!--
/* Font Definitions */
@font-face
{font-family:Calibri;
panose-1:2 15 5 2 2 2 4 3 2 4;}
@font-face
{font-family:Tahoma;
panose-1:2 11 6 4 3 5 4 4 2 4;}
/* Style Definitions */
p.MsoNormal, li.MsoNormal, div.MsoNormal
{margin:0in;
margin-bottom:.0001pt;
font-size:12.0pt;
font-family:"Times New Roman","serif";}
a:link, span.MsoHyperlink
{mso-style-priority:99;
color:blue;
text-decoration:underline;}
a:visited, span.MsoHyperlinkFollowed
{mso-style-priority:99;
color:purple;
text-decoration:underline;}
p.MsoAcetate, li.MsoAcetate, div.MsoAcetate
{mso-style-priority:99;
mso-style-link:"Balloon Text Char";
margin:0in;
margin-bottom:.0001pt;
font-size:8.0pt;
font-family:"Tahoma","sans-serif";}
span.hoenzb
{mso-style-name:hoenzb;}
span.im
{mso-style-name:im;}
span.BalloonTextChar
{mso-style-name:"Balloon Text Char";
mso-style-priority:99;
mso-style-link:"Balloon Text";
font-family:"Tahoma","sans-serif";}
span.EmailStyle21
{mso-style-type:personal-reply;
font-family:"Calibri","sans-serif";
color:#1F497D;}
.MsoChpDefault
{mso-style-type:export-only;
font-family:"Calibri","sans-serif";}
@page WordSection1
{size:8.5in 11.0in;
margin:1.0in 1.0in 1.0in 1.0in;}
div.WordSection1
{page:WordSection1;}
--></style><!--[if gte mso 9]><xml>
<o:shapedefaults v:ext="edit" spidmax="1026" />
</xml><![endif]--><!--[if gte mso 9]><xml>
<o:shapelayout v:ext="edit">
<o:idmap v:ext="edit" data="1" />
</o:shapelayout></xml><![endif]-->
</head>
<body lang="EN-US" link="blue" vlink="purple">
<div class="WordSection1">
<p class="MsoNormal"><span \
style="font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1F497D">Are \
you saying you want to use SAS ® to execute Teradata ® commands on Oracle ® \
data? I know next to nothing about either Teradata ® or Oracle ®, but to me \
this sounds like an impossible request. When I searched Lex Jansen's site I \
found a paper seems to give SAS ® equivalents of Teradata ® queries. (I only \
skimmed the paper). I think that would be the only thing you can do to get what \
you want (if my understanding of your question is accurate). The paper in \
question is "Teradata ® for the SAS ® Programmer: Ordered Analytical Functions, \
Hash Objects, ANSI SQL: 2003 (19-2011)." <o:p></o:p></span></p>
<p class="MsoNormal"><span \
style="font-size:11.0pt;font-family:"Calibri","sans-serif";color:#1F497D"><o:p> </o:p></span></p>
<p class="MsoNormal"><b><span \
style="font-size:10.0pt;font-family:"Tahoma","sans-serif"">From:</span></b><span \
style="font-size:10.0pt;font-family:"Tahoma","sans-serif""> \
SAS(r) Discussion [mailto:SAS-L@LISTSERV.UGA.EDU] <b>On Behalf Of </b>Baba s<br>
<b>Sent:</b> Tuesday, January 26, 2016 11:05 AM<br>
<b>To:</b> SAS-L@LISTSERV.UGA.EDU<br>
<b>Subject:</b> Re: can sas processing levarage of teradata<o:p></o:p></span></p>
<p class="MsoNormal"><o:p> </o:p></p>
<div>
<p class="MsoNormal">Hi,<o:p></o:p></p>
<div>
<p class="MsoNormal">There is data in oracle,i wanted to know can SAS processing \
leverage of Teradata. Here there is no data in Teradata. Please let me know what is \
the process to running query to read oracle data with sas and \
teradata.<o:p></o:p></p> </div>
<div>
<p class="MsoNormal"><o:p> </o:p></p>
</div>
<div>
<p class="MsoNormal">Regards,<o:p></o:p></p>
</div>
<div>
<p class="MsoNormal">Baba.<o:p></o:p></p>
</div>
</div>
<div>
<p class="MsoNormal"><o:p> </o:p></p>
<div>
<p class="MsoNormal">On Tue, Jan 26, 2016 at 9:25 AM, Nat Wooding <<a \
href="mailto:nathani@verizon.net" target="_blank">nathani@verizon.net</a>> \
wrote:<o:p></o:p></p> <p class="MsoNormal">Baba<br>
<br>
I have never worked with Teradata but hopefully someone else on the list<br>
will comment. You call always contact SAS Tech. Support.<br>
<span style="color:#888888"><br>
<span class="hoenzb">Nat</span><br>
</span><br>
<span class="im">-----Original Message-----</span><br>
<span class="im">From: SAS(r) Discussion [mailto:<a \
href="mailto:SAS-L@LISTSERV.UGA.EDU">SAS-L@LISTSERV.UGA.EDU</a>] On Behalf Of Baba \
s</span><o:p></o:p></p> <div>
<div>
<p class="MsoNormal">Sent: Tuesday, January 26, 2016 8:58 AM<br>
To: <a href="mailto:SAS-L@LISTSERV.UGA.EDU">SAS-L@LISTSERV.UGA.EDU</a><br>
Subject: Re: can sas processing levarage of teradata<br>
<br>
Hi Nat,Thank you replying.i want to know how to optimize data loading using<br>
Sas and teradata.As per my knowledge 1.for base Sas:need to have Sas access<br>
Interface to teradata 2.For Di studio:there is teradata loader under<br>
access.these two are options are useful to processing leverage of teradata.i<br>
have researched many articles in the above link(which you provided in the<br>
previous email) I did not find any useful info.coild you please help me<br>
above two points are correct.Regards,Baba.<br>
Sent from my iPhone<br>
<br>
> On Jan 25, 2016, at 9:00 PM, Nat Wooding <<a \
href="mailto:nathani@VERIZON.NET">nathani@VERIZON.NET</a>> wrote:<br> ><br>
> If you go to Lex Jansen's site and search for Teradata, you will find a<br>
number of papers from SAS Institute as well as papers presented at user's<br>
group meetings.<br>
><br>
> Nat Wooding<br>
><br>
> <a href="http://www.lexjansen.com/search/searchresults.php" \
target="_blank">http://www.lexjansen.com/search/searchresults.php</a><br> ><br>
><br>
><br>
> -----Original Message-----<br>
> From: SAS(r) Discussion [mailto:<a \
href="mailto:SAS-L@LISTSERV.UGA.EDU">SAS-L@LISTSERV.UGA.EDU</a>] On Behalf Of<br> \
> Baba s<br> > Sent: Monday, January 25, 2016 8:46 PM<br>
> To: <a href="mailto:SAS-L@LISTSERV.UGA.EDU">SAS-L@LISTSERV.UGA.EDU</a><br>
> Subject: can sas processing levarage of teradata<br>
><br>
> Hi,<br>
><br>
> Please let me know can sas processing levarage of teradata.<br>
><br>
> Regards,<br>
> Baba.<br>
<br>
><o:p></o:p></p>
</div>
</div>
</div>
<p class="MsoNormal"><o:p> </o:p></p>
</div>
</div>
<div>************* IMPORTANT - PLEASE READ ********************<br><div>This e-mail, \
including attachments, may include confidential and/or <span style="line-height: \
1.22;">proprietary information, </span><span style="line-height: 1.22;">and may \
be used only by the person or entity to which it is addressed. If </span><span \
style="line-height: 1.22;">the reader of this </span><span style="line-height: \
1.22;">e-mail is not the intended recipient or his or her authorized agent, \
the </span><span style="line-height: 1.22;">reader is hereby </span><span \
style="line-height: 1.22;">notified that any dissemination, distribution or copying \
of this e-mail is </span><span style="line-height: 1.22;">prohibited. If \
you </span><span style="line-height: 1.22;">have received this e-mail in error, \
please notify the sender by replying to </span><span style="line-height: \
1.22;">this message </span><span style="line-height: 1.22;">and delete this \
e-mail immediately.</span></body> </html>
[prev in list] [next in list] [prev in thread] [next in thread]
Configure |
About |
News |
Add a list |
Sponsored by KoreLogic