Why TPT can not be used when transfter data from Teradata to SAS table?

[Jade_SAS]

Hi All,

   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);

Run;

    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);

Run;

 /*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!

Jade

[kiranv_]

can you try through libname statement as shown below.

Libname tera Teradata user=testuser pw=testpw FASTEXPORT=YES;

[Jade_SAS]

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;

[kiranv_]

did you see whether this did tpt fastexport

[Jade_SAS]

fastexport works, but not the TPT. Thank you!

[sathya66]

Hi ,

Have you got any solution for this? we are on the same situation.

Thanks,

SS