Desktop productivity for business analysts and programmers

Connection to Teradata

Reply
Occasional Learner
Posts: 1

Connection to Teradata

I'm trying to run a program where the initial step connects to Teradata; however, I'm getting an error with the authdomain statement.

 

proc sql exec feedback stimer;

connect to teradata (authdomain=teradataauth TDPID=DWPROD2 MODE=TERADATA CONNECTION=GLOBAL); *10-26-2016;

create table dat.cancer_&client as

select * from connection to teradata (

select distinct.....

 

This is the start of the statement and the error is twofold:

 

1.  Warning: No login information was available for authdomain teradatauth...

2. ERROR:  Teradata connection: MTDP: EM_NEWCONN(207): Error in doing a network connect...

 

I'm using identical code that a colleague uses yet they have no issues.  Could it be something in my EG environment setup?

Ask a Question
Discussion stats
  • 0 replies
  • 234 views
  • 0 likes
  • 1 in conversation