User-Defined Methods - Preprocessor2 for Embedded SQL

Teradata Preprocessor2 for Embedded SQL Programmer Guide

Product
Preprocessor2 for Embedded SQL
Release Number
15.10
Language
English (United States)
Last Update
2018-10-07
dita:id
B035-2446
lifecycle
previous
Product Category
Teradata Tools and Utilities

Custom functions can also be created that are explicitly connected to UDTs; these are known as User‑Defined Methods (UDMs).

For use with PP2, create the UDMs from files on the server. The CREATE METHOD statement must indicate that the file(s) containing the definitions of the methods are located on the server. Creating UDMs from file(s) located on the client is not supported.

For more information on UDTs and UDMs, see:

  • Data Dictionary (B035‑1092) at http://www.info.teradata.com
  • Working with User‑Defined Types and User‑Defined Methods with the Teradata Client Products; this is a Teradata Orange Book. For information on how to access Orange Books, see the Teradata Tools and Utilities Release Definition (B035‑2029) at http://www.info.teradata.com.