topic Re: error when copying teradata in SAS in SAS Data Management

error when copying teradata in SAS

Jade_SAS — Wed, 23 Aug 2017 20:47:50 GMT

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

Re: error when copying teradata in SAS

kiranv_ — Wed, 23 Aug 2017 20:54:13 GMT

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

Re: error when copying teradata in SAS

Patrick — Wed, 23 Aug 2017 23:05:03 GMT

@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.