Upload sas table to Teradata with data step.

Fae — Thu, 27 Feb 2020 21:30:30 GMT

I try to upload a 100k single column table (string variable with length = 10) to Teradata with the code below. After around 5-10 mins, in the Task status, it will go from "Running" to "complete" but stuck there for at least 30-60mins.

libname TDWORK teradata connection=global dbmstemp=yes tdpid=dbc user=&EDW_USER. password=&EDW_PW.;

data tdwork.tempTBL;
set tempTBL;
run;

Re: Upload sas table to Teradata with data step.

ChrisNZ — Fri, 28 Feb 2020 02:05:48 GMT

You'd have to ask the Teradata admins what is happening during that half hour, if anything,

Note that this is not the recommended way to upload data.

You may find this document interesting: Effectively Moving SAS Data into Teradata

topic Re: Upload sas table to Teradata with data step. in SAS Programming

Upload sas table to Teradata with data step.

Re: Upload sas table to Teradata with data step.