TPT_DATA_ENCRYPTION= Data Set Option

Specifies whether to fully encrypt SQL requests, responses, and data when SAS sends data to Teradata for Fastload, MultiLoad, or Multi-Statement insert that uses the TPT API.

Valid in: DATA and PROC steps (when accessing DBMS data using SAS/ACCESS software)
Category: Bulk Loading
Default: NO
Requirement: To use this option, you must first specify TPT=YES.
Data source: Teradata
See: Maximizing Teradata Load Performance, Using the TPT API, BULKLOAD= LIBNAME option, BULKLOAD= data set option, MULTILOAD= data set option, MULTISTMT= data set option, TPT= LIBNAME option, TPT= data set option

Table of Contents

Syntax

TPT_DATA_ENCRYPTION=YES | NO

Syntax Description

YES

specifies that all communication between the Teradata client and server is encrypted when using the TPT API.

NO

specifies that all communication between the Teradata client and server is not encrypted when using the TPT API.

Details

Note: Starting in SAS 9.4M9, FastLoad and MultiLoad are no longer supported. Documentation remains for users who have not upgraded to SAS 9.4M9.

You can ensure that SQL requests, responses, and data that are transferred between the Teradata client and server are encrypted when using the TPT API. See your Teradata documentation for details.

Last updated: February 3, 2026