SHOW FUNCTION MAPPING Examples | Teradata Vantage - 17.10 - Example: Showing a Function Mapping Definition - Advanced SQL Engine - Teradata Database

Teradata Vantage™ - SQL Data Definition Language Syntax and Examples

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

This statement displays the definition for the function mapping Interpolator in the database appl_view_db.

SHOW FUNCTION MAPPING appl_view_db.Interpolator;

Following is the sample output.

CREATE FUNCTION MAPPING appl_view_db.Interpolator
FOR Interpolator SERVER coprocessor 
MAP JSON ( '{ "function_version": "1.0" }') 
USING
input_table IN TABLE,
time_table IN TABLE,
count_row_number IN TABLE,
TimeColumn('periodcol'), 
ValueColumns('stockprice');