- Installing the RODBC Package - Aster R

Teradata Aster® R User GuideUpdate 3

Aster R
December 2017
Programming Reference
User Guide
If users have Internet access from the queen node, then users can install the RODBC driver using the R client inside the R sandbox area. Follow the steps in this section, and complete this procedure using the Linux root privileges account.
#su –
If users do not have Internet access from the queen node, this task can be done by downloading the RODBC package from the CRAN website https://cran.r-project.org/src/contrib and installing the package on the queen node using the R CMD command.
  1. Soft shutdown the Aster Database.
    # ncli system softshutdown
  2. Set up the environment.
    # chroot /opt/aster/third-party/R
    # export LD_LIBRARY_PATH=$LD_LIBRARY_PATH:/usr/lib:/usr/local/lib/stage/clients-odbc-linux64/unixODBC/lib
    # export ODBC_INCLUDE="/usr/include"
    # export ODBC_LIBS="/usr/lib"
    # export LD_RUN_PATH="/usr/lib"
  3. Install the RODBC using the R client.
    # R
    > q()
    Save workspace image? [y/n/c]: n
    # exit
    While installing the RODBC package in the R client, when prompted, choose the option from the list such as "CA 96/97(CA--)" whichever works.