GLOP Data - 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
ft:locale
en-US
ft:lastEdition
2025-03-30
dita:mapPath
iiv1628111441820.ditamap
dita:ditavalPath
qkf1628213546010.ditaval
dita:id
qnu1472247494689
lifecycle
latest
Product Category
Teradata Vantageā„¢

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.