I am trying to create a volatile table in teradata using pro ds2 but I get the following error message LIBNAME _tdwork TERADATA SERVER=tdb AUTHDOMAIN=TeradataAuth MODE=teradata DBMSTEMP=yes CONNECTION=global query_band="SYS_PROJECT=&sys_project.;SYS_GROUP=&sys_group.;"; proc ds2; data _tdwork.cars; method run(); set cars; end; enddata; run; quit; ERROR: Compilation error.
ERROR: General error No more room in database ABBCC.
ERROR: Unable to execute CREATE TABLE statement for table _tdwork.cars. But if I change the destination to the permanent library in teradata, the codes run without any problem libname _DATALAB TERADATA server=tdb schema=&SYS_DATALAB AUTHDOMAIN=teradataauth
query_band="SYS_PROJECT=&sys_project.;SYS_GROUP=&sys_group.;";
proc ds2;
data _datalab.cars;
method run();
set cars;
end;
enddata;
run;
quit; Using a data step creates the volatile table with no problem data _tdwork.cars;
set cars;
run; using the fastload=yes option to upload data to the temporary library also gives the following error data _tdwork.cars(fastload=yes);
set cars;
run;
ERROR: Teradata connection: No more room in database ABBACC. Correct error and restart as an APPEND process with option
TPT_RESTART=YES. Since no checkpoints were taken, if the previous run used FIRSTOBS=n, use the same value in the restart.
NOTE: The DATA step has been abnormally terminated.
NOTE: The SAS System stopped processing this step because of errors.
NOTE: There were 1 observations read from the data set WORK.CARS.
WARNING: The data set _TDWORK.car may be incomplete. When this step was stopped there were 0 observations and 15 variables.
ERROR: ROLLBACK issued due to errors for data set _TDWORK.cars.DATA.
... View more