Teradata load error

archana — Wed, 05 Nov 2014 18:54:44 GMT

proc append base=db.acct (TPT=YES MULTISTMT=YES TPT_PACKMAXIMUM=YES

keep=x y z) data=curr_acct;

run;

I am getting the below error-

NOTE: Appending WORK.CURR_ACCT to db.acct.

NOTE: BASE data set does not exist. DATA file is being copied to BASE file.

NOTE: SAS variable labels, formats, and lengths are not written to DBMS tables.

WARNING: Engine TERADATA does not support SORTEDBY operations. SORTEDBY information cannot be copied.

Re: Teradata load error

jakarman — Wed, 05 Nov 2014 19:30:50 GMT

There are several aspects that Teradata dataset behave different as to SAS datasets.

See SAS/ACCESS(R) 9.4 for Relational Databases: Reference, Fifth Edition (Maximizing Teradata Load Performance)

First create the data set in Teradata with 0 observations. Take care to define a primary index (in Teradata context) on a suited variable or use no primary index.

Then append all data to that dataset.

A Teradata dataset does not support all kind of SAS dataset options. A fixed ordering in TD does not exist (SQL RDBMS). Do not think in ordering physical data anymore.

When you need an ordered list you need to specify that ordered when retrieving the data.

topic Teradata load error in SAS Procedures

Teradata load error

Re: Teradata load error