Becoming a Member of a GLOP Set | Global and Persistent Data | Teradata Vantage - 17.10 - Becoming a Member of a GLOP Set - Advanced SQL Engine - Teradata Database

Teradata Vantageā„¢ - SQL External Routine Programming

Product
Advanced SQL Engine
Teradata Database
Release Number
17.10
Release Date
July 2021
Content Type
Programming Reference
Publication ID
B035-1147-171K
Language
English (United States)

An external routine can be a member of one GLOP set (although more than one external routine can be a member of the same GLOP set). To make an external routine a member of a GLOP set, use the USING GLOP SET clause when you define the external routine.

Here is an example that defines a UDF called GLOP_Manager and uses the USING GLOP SET clause to make the UDF a member of the GLOP_Set_1001 GLOP set:

CREATE FUNCTION GLOP_Manager(Record_n INTEGER)
RETURNS INTEGER
LANGUAGE C
USING GLOP SET GLOP_Set_1001
NO SQL
PARAMETER STYLE SQL
EXTERNAL NAME 'CS!glop_manager!glop_manager.c';

For details on the USING GLOP SET clause, see Teradata Vantageā„¢ - SQL Data Definition Language Syntax and Examples, B035-1144.