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;
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;
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?
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.
Build your skills. Make connections. Enjoy creative freedom. Maybe change the world. Registration is now open through August 30th. Visit the SAS Hackathon homepage.
Register today!Learn how use the CAT functions in SAS to join values from multiple variables into a single value.
Find more tutorials on the SAS Users YouTube channel.