16.20 - Creating the ExecR System Table Operator - Advanced SQL Engine - Teradata Database

Teradata Vantage™ - SQL External Routine Programming

Advanced SQL Engine
Teradata Database
Release Number
Release Date
April 2020
Content Type
Programming Reference
Publication ID
English (United States)

The ExecR system table operator is used to execute R scripts. Run the optional Database Initialization Program (DIP) script DipRTblOp to create the ExecR table operator. The DipRTblOp DIP script is not run as part of the DIPALL script. You must run it separately.

ExecR resides in the td_sysgpl database.

For information about DIP, see Teradata Vantage™ - Database Utilities , B035-1102 .

The following is an example of how to run the DipRTblOp script from a Advanced SQL Engine primary (PDN) node:
#cnsterm 6
Input Supervisor Command:
> start dip
Started 'dip' in window 1

Input Supervisor Command:
> ^C -- <control C>
#cnsterm 1

Attempting to connect to CNS...Completed
Type the password for user DBC or press the Enter key to quit:
> xxx
***Logon successfully completed.

Select one of the following DIP SQL scripts to execute:
     (Press the Enter key to quit)

40. DIPRTBLOP - R Table Operator

> 40
Please wait...

DIPRTBLOP is complete
Please review the results in /var/opt/teradata/tdtemp/dip40.txt on node 1-1

Would you like to execute another DIP script (Y/N)?
> N

Exiting DIP...