Adding Mappings and Data to a GLOP Set | Teradata Vantage - Adding Mappings and Data to a GLOP Set - Advanced SQL Engine - Teradata Database

SQL External Routine Programming

Product
Advanced SQL Engine
Teradata Database
Release Number
17.10
Published
July 2021
Language
English (United States)
Last Update
2021-07-27
dita:mapPath
rin1593638965306.ditamap
dita:ditavalPath
rin1593638965306.ditaval
dita:id
B035-1147
lifecycle
previous
Product Category
Teradata Vantageā„¢

You can add up to eight GLOP mappings to a GLOP set. To add a mapping and GLOP data to a GLOP set, use the DBCExtension.GLOP_Add system stored procedure. Because the data that you add to a GLOP set must have a BLOB data type, consider using a UDF that generates the data and returns it as a BLOB type.

Here is an example that adds a system type GLOP mapping and data to the GLOP_Set_1001 GLOP set. A UDF called GLOP_System_Data generates the BLOB data.

CALL DBCExtension.GLOP_Add
   ('GLOP_Set_1001','SY', NULL, 'CompanyInfo',
    'N', 0, 'N', 'W', 'E', 0, -1, 1, GLOP_System_Data());

For details on the DBCExtension.GLOP_Add system stored procedure, see DBCExtension.GLOP_Add Stored Procedure.

For a complete example that creates a GLOP set and uses a UDF to generate the BLOB data for a GLOP mapping, see C Function Using GLOP Data.