SQL Definition for the Function That Uses GLOP Data - Teradata Vantage - Analytics Database

SQL External Routine Programming

Deployment
VantageCloud
VantageCore
Edition
VMware
Enterprise
IntelliFlex
Product
Analytics Database
Teradata Vantage
Release Number
17.20
Published
June 2022
ft:locale
en-US
ft:lastEdition
2026-03-06
dita:mapPath
iiv1628111441820.ditamap
dita:ditavalPath
qkf1628213546010.ditaval
dita:id
qnu1472247494689
lifecycle
latest
Product Category
Teradata Vantageā„¢

Here is the SQL statement for the function that reads GLOP data. The USING GLOP SET clause makes the UDF a member of the MyGlopTestSet GLOP set.

REPLACE FUNCTION glop_map1(record_n INTEGER)
RETURNS VARCHAR(30)
LANGUAGE C
USING GLOP SET MyGlopTestSet
NO SQL
PARAMETER STYLE SQL
EXTERNAL NAME 'CS!glop_map1!glop_map1.c';

ALTER FUNCTION glop_map1 execute not protected;