topic Re: ERROR: Teradata prepare: Object does not exist. in SAS Programming

ERROR: Teradata prepare: Object does not exist.

deepakkailay — Wed, 12 Sep 2018 15:24:21 GMT

Hi,

I am using libname to create temp table and using it with proc sql to access it.

I am able to run the code on SAS EG but it is hitting the error on UNIX that Teradata prepare: Object 'migrated_201401' does not exist.

%let tag_value=migrated_201401;
options sastrace=',,,d' sastraceloc=saslog;

libname mytd teradata user=&user. password=&password. tdpid=edwprod connection=global dbmstemp=yes mode=teradata dbcommit=0;

proc delete data=mytd.&tag_value.; run;

proc append data = only_cl_tids_migrated base = mytd.&tag_value. (tpt=no dbcommit=5000) force; run;

proc sql;
reset INOBS = max OUTOBS = max LOOPS = MAX NOFLOW NOFEEDBACK NOPROMPT NONUMBER;
connect to teradata(tdpid = edwprod database = consumer user =&user. password=&password. connection=global);
create table test as
select * from connection to teradata
(
select a.*,
b.*

from &tag_value. a
join tag_tbl b /* table present on my teradata system*/
on a.acct= b.acct
);
quit;

ERROR: Teradata prepare: Object 'migrated_201401' does not exist. SQL statement was:

Please provide some guidance.

thanks in advance.

Re: ERROR: Teradata prepare: Object does not exist.

kiranv_ — Thu, 13 Sep 2018 12:29:06 GMT

i think you are not referencing Teradata database name and your just mentioning table name and hence it is looking for a volatile table(kind of work table in SAS). You need to have proper database name in front of &tag_value, something like yourdatabase..&tag_value.

Re: ERROR: Teradata prepare: Object does not exist.

deepakkailay — Thu, 13 Sep 2018 14:23:00 GMT

Thanks for the reply, actually I am creating the this tag table with proc append by using library(bridge with teradata).

there is no need to use libname here. same code is working fine on SAS EG but it is not working on UNIX.

Re: ERROR: Teradata prepare: Object does not exist.

Tom — Thu, 13 Sep 2018 14:30:20 GMT

You need to show more of the log.

Did the PROC APPEND step really create the table in Teradata?

Are your connection strings between your LIBNAME and CONNECT statement actually the same? If not then SAS will make a NEW connection to Teradata and not be able to see the temporary table.

Are you using a different account in Teradata between the two different runs? Perhaps they have different permissions in Teradata.

Re: ERROR: Teradata prepare: Object does not exist.

deepakkailay — Fri, 14 Sep 2018 10:41:02 GMT

HI,

Thanks for your help. I just added database= options with libname and specified the database that I am using below with the proc sql. it worked fine.

Thanks