topic Re: ERROR: Teradata execute: Right truncation of string data. in SAS Data Management

ERROR: Teradata execute: Right truncation of string data.

steve_db — Fri, 15 Feb 2013 22:27:45 GMT

I wrote a load to Teradata using SAS DI 4.2.

I'm using a Join with USER WRITTEN body to do the

proc sql ;

connect to TERADATA

(

SERVER=THE_SERVER AUTHDOMAIN='the_auth_domain' SCHEMA=the_schema );

execute (

INSERT INTO target_table

(column1, column2, etc)

Select column1, column2, etc.

FROM source1

INNER JOIN source2 on SOURCE1.COLUMNX= SOURCE2.COLUMNX;)

by Teradata;

when run

ERROR: Teradata execute: Right truncation of string data.

btw - this is a known problem with SAS interface to Teradata: 14383 - "ERROR: Teradata execute: Right truncation of string data" when usingthe SAS/ACCESS Interface to Teradata

the workaround is to:

To resolve this problem, use MODE=TERADATA. This MODE is documented in

the Teradata white paper. Please see the link below:

how would I do that in SAS DI?

Re: ERROR: Teradata execute: Right truncation of string data.

Tom — Sat, 16 Feb 2013 04:18:50 GMT

Did you try adding the MODE option to the connect statement?

proc sql ;

connect to TERADATA

(

SERVER=THE_SERVER AUTHDOMAIN='the_auth_domain' SCHEMA=the_schema

MODE=TERADATA

)

;

execute

(

INSERT INTO target_table (column1, column2, etc)

Select column1, column2, etc.

FROM source1

INNER JOIN

source2

on SOURCE1.COLUMNX= SOURCE2.COLUMNX

) by Teradata

;

Re: ERROR: Teradata execute: Right truncation of string data.

Patrick — Sat, 16 Feb 2013 06:37:51 GMT

The SAS Note you posted is for SAS8.2. Are you sure that the error is not simply caused by a Teradata column too short for the string you want to insert?

Re: ERROR: Teradata execute: Right truncation of string data.

steve_db — Mon, 18 Feb 2013 12:54:24 GMT

thanks Tom. Adding MODE=TERADATA option to the CONNECT statement worked for me.