12-11-2017 12:07 PM
I guess the TPT is not set up correctly on the System.
I am using SAS server on Linux. I can use TPT to transfer data from SAS to Teradata table in SAS EG. The coding is as below:
Data TDLib.SAS_To_TD (tpt=yes fastload=yes tpt_max_sessions=4 );
set sashelp.shoes (obs=5);
But when I transfer data from Teradata to SAS table in SAS EG using the coding below, I got a note (in the EG log file) said that the TPT was not used .
Data work.TD_To_SAS ;
Set TDlib.visits_table (tpt=yes fastexport=yes tpt_max_sessions=4);
/*NOTE: Teradata connection: TPT (the default) was NOT used, the FastExport utility was used instead.*/
Do you have any idea what software is missing on the SAS server side or Teradata server side? Thank you!
12-11-2017 01:48 PM
12-12-2017 09:13 PM
Thank you, I tried the following with Server and database, the libname statement works. But my question is the TPT can not be used when transfer data from Teradata to SAS table.
Libname tera Teradata server=Teradata database=testDB user=testuser pw=testpw FASTEXPORT=YES;