Error loading sas dataset in teradata volatile table

nickspencer — Sun, 15 Dec 2019 02:27:30 GMT

I am trying to load SAS dataset into a teradata table but I am getting error while using multistmt option with proc append. My program looks like below.

Libname tdwork teradata user=“xxxxx” password=“xxxxx”
tdpid =“xxxx” connection=global dbmstemp=yes;

proc sql;
connect to teradata (user=“xxxxxx” password=“xxxxxx” tdpid=“xxxxx” connection =global);

execute ( create multiset volatile table test_tera
(column1 char(40))
no primary index
on commit preserve rows)
by teradata;
execute (commit work) by teradata;
quit;

proc append base=tdwork.test_tera(multistmt=yes)
data =dataset1;
run;

ERROR: Teradata connection: object ‘test_tera’ does not exist. Correct error and restart as an append process with option TPT_RESTART=YES. Since no checkpoints were taken, if previous run used FIRSTOBS=n, use the same value in the restart.

Am I doing something incorrectly? When I remove multistmt option, it is running forever. I thought multistmt would work with volatile table.

Any help is appreciated

Thanks

Re: Error loading sas dataset in teradata volatile table

ChrisNZ — Mon, 16 Dec 2019 02:25:50 GMT

You might get better luck on a Teradata forum.

SAS just passes the command as is.

If one command works and the other does not, it looks like a Teradata issue.

topic Error loading sas dataset in teradata volatile table in SAS Programming

Error loading sas dataset in teradata volatile table

Re: Error loading sas dataset in teradata volatile table