17.10 - About GLOP Data - Advanced SQL Engine - Teradata Database

Teradata Vantageā„¢ - SQL External Routine Programming

Advanced SQL Engine
Teradata Database
Release Number
Release Date
July 2021
Content Type
Programming Reference
Publication ID
English (United States)

GLOP data is a type of memory mapped data available to external routines where the data persists beyond the life of one invocation of an external routine.

The persistence, as well as the data that is presented to a specific external routine, is based on specific boundaries such as a role or user account.

For example, consider GLOP data that is based on a user account. The data that an external routine has access to is based on the user who invokes the external routine. The data is available for an external routine to use until the user logs off.

Using stored procedures in the DBCExtension system database, you place GLOP data (as a BLOB) in a system table (also in the DBCExtension database) with particular specifications. The data from this table is available in memory on all nodes and is presented to external routines that are properly configured to use the data.