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

 

Ready to join fellow brilliant minds for the SAS Hackathon?

Build your skills. Make connections. Enjoy creative freedom. Maybe change the world. Registration is now open through August 30th. Visit the SAS Hackathon homepage.

Register today!
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.

Click image to register for webinarClick image to register for webinar

Classroom Training Available!

Select SAS Training centers are offering in-person courses. View upcoming courses for:

View all other training opportunities.

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