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 Analytics Database 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...