DATA Step, Macro, Functions and more

Error while loading SAS data into Teradata table.

Reply
Occasional Contributor
Posts: 15

Error while loading SAS data into Teradata table.

Hi,

I am trying to load sas dataset into teradata table. I am creating a new teradata table and then using insert into statement to load the data from SAS dataset to teradata table. I have written the following code to achieve the goal. But I am getting the following error message. I have never encounter this error message before and I have no idea what this means. Can some one please help me out to resolve this issue?

Thanks

ERROR: Commit: Options Parcel information is invalid.

ERROR: ROLLBACK issued due to errors for data set TERAU.sa_dca.DATA.

libname terau teradata user=xxxx pass="&xxx" tdpid=xxx database=xxxxxx bulkload=yes;

proc sql;
connect to teradata(user=xxxx pass="&xxx" tdpid=xxx);
exec(commit) by teradata;
exec(drop table sa_dca) by teradata;
exec(commit) by teradata;
disconnect from teradata;
quit;
  
proc sql;
connect to teradata(user=xxxx pass="&xxx" tdpid=xxx );
exec (commit) by teradata;
exec (create table sa_dca
(var1 float
)
primary index (var1)) by teradata;
exec (commit) by teradata;
quit;
RUN;

proc sql;
insert into terau.sa_dca (FastLoad=yes Sessions=4)
( select var1
from dcindex);
quit;

Super User
Super User
Posts: 6,502

Error while loading SAS data into Teradata table.

Where did the error occur?

Also why are you working so hard to drop/define the tables? Just tell SAS to do it.

Something like this:

libname terau teradata user=xxxx pass="&xxx" tdpid=xxx database=xxxxxx bulkload=yes;

proc sql noprint;

  drop table terau.sa_dca;

quit;

data terau.sa_dca (fastload=yes dbcreate_table_opts=''primary index(var1)'' );

  set dcindex (keep=var1);

quit;

Occasional Contributor
Posts: 15

Error while loading SAS data into Teradata table.

The error is coming at the insert into step.

Even when I am running the code that you provided, I am getting the same error. I have never encountered this error before. Is it possible that some kind of teradata driver missing from my PC?

Super User
Super User
Posts: 6,502

Error while loading SAS data into Teradata table.

Best to ask SAS Support. They have SAS/Teradata joint team that has been very helpful to me for the little I have used Teradata so far.

Ask a Question
Discussion stats
  • 3 replies
  • 1250 views
  • 0 likes
  • 2 in conversation