1.0 - Installing Custom Files - Teradata Vantage

Teradata® Vantage User Guide

Product
Teradata Vantage
Release Number
1.0
Published
January 2019
Language
English (United States)
Last Update
2020-03-11
dita:mapPath
hfp1506029122470.ditamap
dita:ditavalPath
hfp1506029122470.ditaval
PrerequisiteThe file must be registered with a SQL identifier on the ML Engine. In the following steps, sql_identifier is the name with which the file file_name.txt is registered with SQL Engine.
An authorized user can install a customized version of a preinstalled model file or input file (a text file) on the ML Engine in the default schema, public schema, or both. In the default schema, only the current user can access the file.
  • Install the file in the default schema:
    CALL SYSUIF.INSTALL_FILE ('sql_identifier',
      'file_name.txt', 'sz!file_name.txt');
    CALL PM.INSTALL_AFILE ('sql_identifier');

    For example:

    CALL SYSUIF.INSTALL_FILE ('default_sentiment_lexicon',
      'default_sentiment_lexicon.txt', 'sz!default_sentiment_lexicon.txt');
    CALL PM.INSTALL_AFILE ('default_sentiment_lexicon');
  • Install the file in the public schema:
    CALL SYSUIF.INSTALL_FILE ('sql_identifier',
      'file_name.txt', 'sz!file_name.txt');
    CALL PM.INSTALL_AFILE_TO_PUBLIC ('sql_identifier');

    For example:

    CALL SYSUIF.INSTALL_FILE ('default_sentiment_lexicon',
      'default_sentiment_lexicon.txt', 'sz!default_sentiment_lexicon.txt');
    CALL PM.INSTALL_AFILE_TO_PUBLIC ('default_sentiment_lexicon');