SAS Data Integration Studio, DataFlux Data Management Studio, SAS/ACCESS, SAS Data Loader for Hadoop and others

error when copying teradata in SAS

Accepted Solution Solved
Reply
Frequent Contributor
Posts: 139
Accepted Solution

error when copying teradata in SAS

Hi All,

 

    I'm copying one table from Teradata to the same location and I get the error below:

   

LIBNAME TD TERADATA SERVER=*** DATABASE=***;

 

Data TD.test1;

set TD.log;

Run;

 

ERROR: Error attempting to CREATE a DBMS table. ERROR: Teradata execute: Length 0 is not allowed for a CHAR, VARCHAR, BYTE, VARBYTE

column..

ERROR: ROLLBACK issued due to errors for data set TD.TEST1.DATA.

 

 

What's the possible reason for this? Thank you!

 

Jade

 


Accepted Solutions
Solution
‎08-30-2017 03:10 PM
Respected Advisor
Posts: 4,131

Re: error when copying teradata in SAS

[ Edited ]

@Jade_SAS

Additionally to what @kiranv_ wrote: Don't use a SAS data step to replicate a DBMS table. Using a SAS data step will most likely result in SAS first pulling all the data from the DB into SAS and then creating the new table and re-loading the data back to the DBMS.

 

Best use PROC SQL or eventually PROC APPEND. 

 

If it would be me then I'd use explicit pass-through SQL for such operations.

View solution in original post


All Replies
PROC Star
Posts: 279

Re: error when copying teradata in SAS

[ Edited ]

do you have any character column with value of '' which is allowed in SAS but not allowed in Teradata after Teradata 14

Solution
‎08-30-2017 03:10 PM
Respected Advisor
Posts: 4,131

Re: error when copying teradata in SAS

[ Edited ]

@Jade_SAS

Additionally to what @kiranv_ wrote: Don't use a SAS data step to replicate a DBMS table. Using a SAS data step will most likely result in SAS first pulling all the data from the DB into SAS and then creating the new table and re-loading the data back to the DBMS.

 

Best use PROC SQL or eventually PROC APPEND. 

 

If it would be me then I'd use explicit pass-through SQL for such operations.

☑ This topic is solved.

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

Discussion stats
  • 2 replies
  • 199 views
  • 1 like
  • 3 in conversation