Creating the ExecR System Table Operator

Teradata® Database on VMware Base, Advanced, Enterprise Tiers Getting Started Guide

brand
Cloud
prodname
Teradata Database on VMware
vrm_release
Deployer 3.02
category
Configuration
Installation
featnum
B035-5958-018K
The ExecR table operator is required and is used to execute R scripts.
  1. Run the DipRTblOp DIP script to create the ExecR table operator. Following is an example of how to run the DipRTblOp script from a Teradata 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...