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-wordmark-2025-midnight.png

Register Today!

Join us for SAS Innovate 2025, our biggest and most exciting global event of the year, in Orlando, FL, from May 6-9. Sign up by March 14 for just $795.


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
  • 375 views
  • 0 likes
  • 2 in conversation