Create ExecR System Table Operator | Teradata Vantage - Creating the ExecR System Table Operator - Advanced SQL Engine - Teradata Database

SQL External Routine Programming

Product
Advanced SQL Engine
Teradata Database
Release Number
17.10
Published
July 2021
Language
English (United States)
Last Update
2021-07-27
dita:mapPath
rin1593638965306.ditamap
dita:ditavalPath
rin1593638965306.ditaval
dita:id
B035-1147
lifecycle
previous
Product Category
Teradata Vantageā„¢

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
Executing DIPRTBLOP
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...