DATA Step, Macro, Functions and more

ERROR: Teradata execute: No more room in database

Accepted Solution Solved
Reply
Contributor
Posts: 46
Accepted Solution

ERROR: Teradata execute: No more room in database

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.


Accepted Solutions
Solution
‎07-06-2016 10:08 AM
Contributor
Posts: 46

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


Solution:
The column names were not the same.

 

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

 

 

View solution in original post


All Replies
Contributor
Posts: 46

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

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
Solution
‎07-06-2016 10:08 AM
Contributor
Posts: 46

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


Solution:
The column names were not the same.

 

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

 

 

☑ This topic is solved.

Need further help from the community? Please ask a new question.

Discussion stats
  • 2 replies
  • 1329 views
  • 0 likes
  • 1 in conversation