Re: Strange SAS teradata message

  • Permalink
  • submit to reddit
  • Email
  • Follow


I have no teradata, but I have an idea, where to look. That name, you use,
is not the real name. Means: behind EM_NOHOST there is something other.
For IP-adresses in TCP/IP there is a file where that substitutions are
contained. For the big WWW that is done by DNS servers, for some local
names, you have the HOSTS file. Maybe the substitute is also something
like a IP-adress.
You should contact your sysadmin with that error message. He can tell you,
how the name is, you can use, or he enters the needed entry in the right
file, so you can use the name you are used to.
Gerhard



On Tue, 10 Jul 2007 08:02:56 -0700, ssegall@GMAIL.COM wrote:

>All,
>Not really sure if that many people in here define Libraries in
>Teradata using SAS, but I'd figure I'd give it a shot.  May be an
>error that shows up using other more popular databases.
>
>I am using the following script that I have always used to define the
>libname statement.
>
> libname XXXXX teradata server=XXXXXXX user=XXXXXX password=XXXXXXXX
>schema=XXXXX;
>
>When I entered this I get the following error.
>
>ERROR: Teradata connection: MTDP: EM_NOHOST(224): name not in HOSTS
>file or names database.  .
>ERROR: Error in the LIBNAME statement.
>
>I have no clue what this means.
>
>I have run the same exact script on my laptop and was able to
>sucessfully connect.  Unfortunately running SAS on my laptop isn't a
>good solution.  Any ideas what the error means or how I might resolve
>it.
>
>Thanks,
>-Steven Segall
0
Reply gerhard.hellriegel (2531) 7/10/2007 3:24:12 PM

See related articles to this posting

comp.soft-sys.sas 131473 articles. 30 followers. Post

0 Replies
158 Views

Similar Articles

[PageSpeed] 15


Reply:

Similar Artilces:

Re: Strange SAS teradata message #3
The ideal way to deliver data from a server is usually to have the server name recorded on the network Domain Name Server so that a request against MYTERROR is translated into an ip address from the most authoritative source. For a variety of reasons, including server security, procedural limitations and delays in updating the DNS, the work-around is sometimes made that the server name is translated into an ip address in the HOSTS file on the client PC. Your alternatives are to have the server name recorded in the DNS (which may not be possible), replace the server name in your library state...

Re: Strange SAS teradata message #2
You're missing the appropriate entry from your "hosts" file. Assuming WinXP, this file will be located at: C:\WINDOWS\system32\drivers\etc\hosts If you open that file in notepad on your two machines, you'll see an entry on the laptop that corresponds to the SERVER you specified in your LIBNAME; you need to paste that line into the hosts file on the workstation and save it. You need admin rights to edit that file, so you'll probably have to call IT. On Tue, 10 Jul 2007 08:02:56 -0700, ssegall@GMAIL.COM wrote: >All, >Not really sure if that many people in here ...

Re: Strange SAS teradata message #4
Maybe I had, but that wasn't the solution. You needed a similar line in your hosts file that referenced the server and its ip address. However, subsequent postings suggest you had a variation on the problem and that it is resolved now. Kind regards David -----Original Message----- From: SAS(r) Discussion [mailto:SAS-L@LISTSERV.UGA.EDU]On Behalf Of ssegall@GMAIL.COM Sent: Friday, 13 July 2007 3:19 AM To: SAS-L@LISTSERV.UGA.EDU Subject: Re: Strange SAS teradata message On Jul 12, 7:44 am, d...@dkvj.biz (David Johnson) wrote: > The ideal way to deliver data from a server is usually ...

Strange SAS teradata message
All, Not really sure if that many people in here define Libraries in Teradata using SAS, but I'd figure I'd give it a shot. May be an error that shows up using other more popular databases. I am using the following script that I have always used to define the libname statement. libname XXXXX teradata server=XXXXXXX user=XXXXXX password=XXXXXXXX schema=XXXXX; When I entered this I get the following error. ERROR: Teradata connection: MTDP: EM_NOHOST(224): name not in HOSTS file or names database. . ERROR: Error in the LIBNAME statement. I have no clue what this means. I have run...

Re: Error message from SAS. Re: Transpose columns to rows in SAS?
Wei , That is a V8 limitation not a V9 limitation. From V9.1.3 1 Data One ; 2 Array aaa (1000000) ; 3 Retain AAA: 0 ; 4 Run ; NOTE: The data set WORK.ONE has 1 observations and 1000000 variables. NOTE: DATA statement used (Total process time): real time 2:52.48 cpu time 2:37.24 Toby Dunn To sensible men, every day is a day of reckoning. ~John W. Gardner The important thing is this: To be able at any moment to sacrifice that which we are for what we could become. ~Charles DuBois Don't get your knickers in a knot. Nothing is solved and i...

RE : RE : sas to teradata insertion error
Hum, yes yes yes, I remember this error....when I got the v9 (again) :-)) I'm sure it's a compatibility problem between the SAS9 and the teradata client which worked fine with the v8 but not very well with v9 (as a old post in relation to Oracle, the RDBMS client have to change when you upgrade SAS). I used insert values statement and I changed to : data SCORE_DESCRIP1; infile datalines dsd dlm='|'; input SCORE_DESC_1 $3. +1 LIB_DESC_1 : $50. ; datalines; .... ; run; proc sql; connect to teradata (user ="&__user3" password="&__pass3" schema="...

RE : Re: RE : Re: copulas and SAS
Thanks, I appreciate your comments,I understand that copula is not the appropriate tool to use, what will be the alternative ? Adel David L Cassell <davidlcassell@MSN.COM> a �crit : joewhitehurst@GMAIL.COM replied: > >Adel, > >You may find the following artilce interesting. [article by Thomas Mikosch not copied] This is a really good article, and a really useful point to make. But 55K is a lot of article to copy. Would it have been easier to point to a URL? The people who read SAS-L as a digest and the people who have slow connections are probably not overly thrilled...

Re: RE : Re: SAS on a Mac
Not sure why this has spawned 3 threads: http://listserv.uga.edu/cgi-bin/wa?A1=ind0704e&L=sas-l#21 ...

Re: RE : Re: copulas and SAS
Adel, Think Joke! But, more seriously, it did prompt me to look up the origins of the copula as a functional. Joe On 9/27/06, adel F. <adel_tangi@yahoo.fr> wrote: > > Hi, > I do not know how this is related to my orginal question. > > My understanding of copula is, it is a joint distribution with uniform > margins, the problem how to obtain a copula which fits better a data? > > If there is any suggestion from members of SAS list, about examples for > copulae with SAS, I will appreciate that > > Thanks a lot > > Adel > Joe Whitehurst <joew...

RE:Re: Re: Re: Your document
*** This is an automated message *** Your message was found to contain a virus in one or more of the attachments. The message has been deleted and will not be delivered. Please virus scan your attachments before re-sending. Your local Help Desk can provide assistance in virus checking/scanning files and attachments. Original Message Details.. Subject : Re: Re: Re: Your document Sender : python-list@python.org Recipients : cward@jmifa.com.au Date : Mon, 10 May 2004 14:37:48 +1000 ...

Re: What does the SAS message mean?
Xu, In my experience, this means t\tou have more than one SAS session running at the same time. The first one locks the registry and the second puts out this warning message, usually at startup time. Look at thhe very beginning of you session log. It could also be due to some other process on your system locking the registry, but this less likely. In most cases, you can ignore the message although I am not familiar with SurveySelect. HTH, Dennis Diskin On 10/17/05, Xu Libin <Libin.Xu@irs.gov> wrote: > > Dear SAS-lers, > > When I ran the following syntax: > proc surveyme...

Re: Strange SAS behavior!
Duck-Hye Yang <dyang@CHAPINHALL.ORG> wrote: > These days I noticed one weird thing. > Even though I specified a variable name to be analyzed (for example, > for proc univariate), I found that the VERY FIRST variable in the order > in a data was used. > > Have any of you experienced this kind of thing ? This would be a strange SAS behavior. Perhaps you should write back (to the list, not to me personally) and demonstrate some simple SAS code, with log and output, demonstrating this behavior, so that we can see what is actually happening. Make the SAS code as short as ...

Re: strange error message
> From: Jonathan Woodring > I get this message now when I run a program today that has > been running bug free for months: > > ERROR: A lock is not available for > EXPORTS.KPCUSTOMERSQL.DATA, lock held by another process this is the result of two sessions or jobs trying to read/write/access a dataset, KPCUSTOMERSQL, in the same libref. be patient or kill the first job/session Ron Fehd the batch maven CDC Atlanta GA USA RJF2 at cdc dot gov ...

Re: Macro with Teradata and SAS
On Thu, 24 Aug 2006 12:50:43 -0400, Nicole Scott <nicole.d.scott@WELLSFARGO.COM> wrote: >I am trying to pass dates using SAS macros with Teradata sql but can't get >teradata to recoginze the values as numeric. > >Can someone help me figure out how to do this? I have included my code and >error message. > >Just to note that I tried single and double quotes but still get an error >message. Teradata sees the values as a colunm with double quotes and a >character string with single quotes. > >Thanks >%Macro Cohort(begdt,enddt,syyyymm,eyyyymm,emmyy);...

how to add fonts to the sas registry (was RE: Re: sas/graph:
Success! A google search led me to: http://support.sas.com/documentation/onlinedoc/base/91/freetype-hub.pdf Which includes the magic option on FONTREG to use the "all" mode. (And now that I look back on the FONTREG docs, I see it there was well :-P). So here's code that works: * =================================== ; proc fontreg mode = all msglevel = verbose ; truetype 'c:\windows\fonts' ; run ; data phoney ; do n = 1 to 2000 ; x = ranuni(-1) ; if n le 1000 then grp = "one" ; else grp = "two" ; output ; end ; run ; gopti...

Re: Strange email messages...
On Wed, 23 Jun 2004 16:28:33 -0400, Five Cats wrote: Those come from email gateway subscribers that have set up a "while I'm out" message without the sensitivity to shutdown their subscription or filter the list out of the auto-responder. Art S. Kagel > Every time I post here, I get a number of strange email messages to the > reply-to address from people telling me they are out... > > WHY? > > I really don't care that people I have never heard of and wouldn't know from > Adam are out of the office. Why on earth are they doing it? ...

Re: SAS/Access for Teradata
On what platform are you using SAS? What version of the Teradata Utilities have you installed? I remember we had to upgrade to TTU 8.2 on our UNIX server when our warehouse moved to V2R6. In particular, we had to install the utilities using all the defaults (i.e. install to /usr). Can you connect to Teradata outside of SAS (using BTEQ)? Perhaps it's a network problem. Assuming you are on UNIX, make sure these environment variables are defined: FEXPLIB=/usr/bin; export FEXPLIB MLOADLIB=/usr/bin; export MLOADLIB FLOADLIB=/usr/bin; export FLOADLIB COPLIB=/usr/lib; export COPLIB COPERR=...

RE: Strange error message
Call Tech Support Upgrade to 9.4 or 10.0 (9.21 is very old) -> -----Original Message----- -> From: svs [mailto:sshumilov@gmail.com] -> Sent: Monday, February 06, 2006 11:17 AM -> To: informix-list@iiug.org -> Subject: Strange error message ->=20 ->=20 -> Hi everyone!!! ->=20 -> lately I got this.... -> Assert Failed: Memory block header corruption detected in -> mt_shm_malloc_segid 2 -> Informix Dynamic Server 2000 Version 9.21.TC5 -> .... -> Results: Unable to repair pool -> Action: Please notify Informix Technical Support. ...

Re: SAS Error Message
bruce.b.allen@WELLSFARGO.COM wrote: >Date: Thu, 22 Mar 2007 15:13:04 -0500 > >Has anyone ever seen the below error? It's a crazy Segmentation Fault >error that I get in the log when trying to execute a shell script from >SAS. The actual log is at the bottom. We can't seem to figure it out. >I'm running SAS for windows version 9. > >I am getting the error when I run the following code: > > > >x '/users/apps/ssg1/data_archive/green_net/run_ftp.sh'; > > > >REMOTE(WFSAS): MetaReady > >REMOTE(WFSAS): /users/apps/ssg1/data_...

Re: SAS Sample 1728 Was ---> Re: SAS Sample 1727
Nice thread guys .... I guess this is what open source development is all about .... Got me thinking about suggesting a code/macro library on sascommunity.org? Any thoughts? ...

Re: SAS Job websites WAS(Re: SAS jobs for freshers in US
On Fri, 24 Mar 2006 11:27:44 -0500, Steven Raimi <steven.raimi@ONSTAR.COM> wrote: >Another very helpful (and focused) web site for SAS jobs is >icrunchdata.com. I'll try to ....post from home later, where I have a set of links (I don't have them at my new job here, which, FYI, I found via Monster). I'll also try to avoid fumble-fingering that accidently posts my messages before I'm done writing them! Steve ...

Re: RE : Re: copulas and SAS #3 674067
joewhitehurst@GMAIL.COM replied: > >Adel, > >You may find the following artilce interesting. [article by Thomas Mikosch not copied] This is a really good article, and a really useful point to make. But 55K is a lot of article to copy. Would it have been easier to point to a URL? The people who read SAS-L as a digest and the people who have slow connections are probably not overly thrilled. I'll refrain from pointing out that you sound like me today. ("Are you sure you want to do this? Here's some material which suggests you should try a different approach..."...

Re: RE : Re: copulas and SAS #3 1556650
Adel, You may find the following artilce interesting. COPULAS: TALES AND FACTSy THOMAS MIKOSCH \But he does not wear any clothes" said the little child in Hans Christian Andersen's \The Emperor's New Clothes". 1. Some preliminary facts When I started writing the paper [19] in 2003 a Google search of the word \copula" gave 10,000 responses. In September 2005 the same search gives 650,000 responses. There is an explosion of activity. What is going on? Many of the web-sites1 found in the Google search are related to mathematical nance, statistics, extreme value theory, a...

Re: SAS/Access for Teradata #4
Thanks Bob for your message. While we are not using UNIX, your reply prompted me to go back and request that our server support person use BTEQ, had to be installed, to test connection and not the software that was initially used. (Turns out the previous test was using OBDC not native teradata drivers) Short anwswer to long story.. BTEQ failed. While the answer was truly a teradata issue (not SAS) I'm posting the solution so that others may learn and not get trapped in the middle (SAS versus teradata). Solution: This problem is being addressed by DR 103605. No code fix is currently av...