BookmarkSubscribeRSS Feed
Fae
Obsidian | Level 7 Fae
Obsidian | Level 7

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;

1 REPLY 1
ChrisNZ
Tourmaline | Level 20

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

 

sas-innovate-2026-white.png



April 27 – 30 | Gaylord Texan | Grapevine, Texas

Registration is open

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!

Register now

How to Concatenate Values

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.

SAS Training: Just a Click Away

 Ready to level-up your skills? Choose your own adventure.

Browse our catalog!

Discussion stats
  • 1 reply
  • 627 views
  • 0 likes
  • 2 in conversation