About GLOP Data - 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™

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.