Distribute Packages | External Routines | Teradata Vantage - Distributing Packages - Analytics Database - Teradata Vantage

SQL External Routine Programming

Deployment
VantageCloud
VantageCore
Edition
Enterprise
IntelliFlex
VMware
Product
Analytics Database
Teradata Vantage
Release Number
17.20
Published
June 2022
Language
English (United States)
Last Update
2023-07-11
dita:mapPath
iiv1628111441820.ditamap
dita:ditavalPath
qkf1628213546010.ditaval
dita:id
B035-1147
lifecycle
latest
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

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.