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

SQL External Routine Programming

Product
Advanced SQL Engine
Teradata Database
Release Number
17.05
17.00
Published
June 2020
Language
English (United States)
Last Update
2021-01-24
dita:mapPath
qwr1571437338192.ditamap
dita:ditavalPath
lze1555437562152.ditaval
dita:id
B035-1147
lifecycle
previous
Product Category
Teradata Vantage™
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

Teradata Database maintains the system tables and updates the information when you back up or restore packages. For details, see Backing Up and Restoring Packages.

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.