In-database processing fails when used with Base SAS® procedures and Teradata Parallel Transporter


An error similar to the following might occur when you use in-database processing with Base SAS procedures if the TPT (Teradata Parallel Transporter) option is set to  yes (default).

/* test sample */
options sastrace = ",,,d" sastraceloc = saslog ;
libname TERALIB teradata user = xxx password = yyy fastexport = YES sqlgeneration=dbms;

proc delete data=x.class; run;
data x.class; set sashelp.class; run;

proc summary data = x.CLASS nway ;
class SEX ;
var HEIGHT ;
output out = WORK.SUM sum= ;
run ;
 
ERROR: Teradata connection: TPT FastExport: EXPORT_OPERATOR: TPT12108:
Output Schema does not match data from SELECT statement.
 

This error occurs because SAS sends to Teradata a query that uses ANSI mode by default, and TPT supports only Teradata mode.

TPT is used mainly for large-volume roundtrips of data. Because one of the purposes of in-database processing is to eliminate large-volume roundtrips of data, TPT should not need to be used for in-database processing.