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;
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
April 27 – 30 | Gaylord Texan | Grapevine, Texas
Walk in ready to learn. Walk out ready to deliver. This is the data and AI conference you can't afford to miss.
Register now and lock in 2025 pricing—just $495!
Still thinking about your presentation idea? The submission deadline has been extended to Friday, Nov. 14, at 11:59 p.m. ET.
Learn how use the CAT functions in SAS to join values from multiple variables into a single value.
Find more tutorials on the SAS Users YouTube channel.
Ready to level-up your skills? Choose your own adventure.