Adding Mappings and Data to a GLOP Set | Teradata Vantage - 17.10 - Adding Mappings and Data to a GLOP Set - 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)

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.