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

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.