topic Re: ERROR: Teradata execute: No more room in database in SAS Programming

ERROR: Teradata execute: No more room in database

cellurl — Thu, 30 Jun 2016 19:43:35 GMT

proc sql;
connect to teradata (MODE=TERADATA user=xxxxx password="xxxxx" tdpid='xxxxxxxxxxx' connection=global);
execute( 

insert into BLAH_DB.table 
select 
*
from blahdb.othertable cst inner join otherdb.tablec ch on cst.cust_acct_nbr = ch.cust_acct_nbr 

) by teradata;
ERROR: Teradata execute: No more room in database BLAH_DB.

Re: ERROR: Teradata execute: No more room in database

cellurl — Thu, 30 Jun 2016 19:44:53 GMT

it is 31 million rows. If I put in "top 1", it works, so it is mad about the size.

Also, If I do it in Teradata SQL Assistant, it loads all 31 million rows with no problem.

Thanks for helping. I am stumped!
Jim

Re: ERROR: Teradata execute: No more room in database

cellurl — Wed, 06 Jul 2016 14:08:47 GMT

Solution:
The column names were not the same.

Somehow that makes it blowup (x-product??)