error when copying teradata in SAS

[Jade_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

[kiranv_]

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

[Patrick · Accepted solution]

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