Distribute Packages | External Routines | Teradata Vantage - 17.10 - Distributing Packages - Advanced SQL Engine - Teradata Database

Teradata Vantage™ - SQL External Routine Programming

Product
Advanced SQL Engine
Teradata Database
Release Number
17.10
Release Date
July 2021
Content Type
Programming Reference
Publication ID
B035-1147-171K
Language
English (United States)
Teradata provides the following tools for you to use to distribute packages to all nodes of an MPP system:
  • A system stored procedure called installsp, located in the SYSLIB database
  • A Microsoft Windows, Call-Level Interface Version 2 (CLIv2) based executable called lobteq from which you call the installsp stored procedure
Additionally, Teradata provides the following system tables in the SYSLIB database for storing information for versioning, backing up, and restoring packages:
  • dem
  • demddl
  • dempart

Vantage maintains the system tables and updates the information when you back up or restore packages. For details, see Backing Up and Restoring Packages [Deprecated].

Before You Begin

Before you can distribute any packages, download lobteq to your Windows client system and verify that the SYSLIB system database contains the installsp stored procedure and dem, demddl, and dempart tables.

  1. Use the following SQL statement to view the objects in the SYSLIB system database:
    HELP DATABASE SYSLIB;
  2. If the information that HELP DATABASE returns does not include the installsp stored procedure or the dem, demddl, dempart tables, execute the DIPDEM script using the Database Initialization Program (DIP) utility.

    For more information on DIP, see Teradata Vantage™ - Database Utilities, B035-1102.

  3. Verify the following privileges:
    • You must have EXECUTE PROCEDURE on the SYSLIB.installsp stored procedure.
    • The SYSLIB database must have EXECUTE FUNCTION on the SYSLIB.installpkg UDF.
  4. Download lobteq to your Windows client system:
    1. Log on to your Windows client system using an Administrator account.
    2. Verify Teradata Tools and Utilities is installed and that all the product dependencies for BTEQ are satisfied.

      For more information on BTEQ product dependencies, see Teradata® Tools and Utilities for Microsoft Windows Installation Guide (B035-2407).

    3. Go to Teradata Downloads and download the UDF Packaging self extractable file to a directory of your choice.
    4. Extract the lobteq executable from the self extractable file.