16.20 - Example: Creating an Instance Method Using a Multidimensional ARRAY Type and a TD_GENERAL Parameter Type - Teradata Database - Teradata Vantage NewSQL Engine

Teradata Vantage™ SQL Data Definition Language Syntax and Examples

Product
Teradata Database
Teradata Vantage NewSQL Engine
Release Number
16.20
Published
March 2019
Language
English (United States)
Last Update
2019-05-24
dita:mapPath
wkf1512081455740.ditamap
dita:ditavalPath
TD_DBS_16_20_Update1.ditaval

This example duplicates Example: Creating an Instance Method Using a Multidimensional ARRAY Type and an SQL Parameter Type except that for this example, the instance method update_measures is written with a TD_GENERAL parameter style.

CREATE INSTANCE METHOD update_measures 
	( a1 source_ary)  
	RETURNS INTEGER
	FOR MEASURES_UDT
	NO SQL
	PARAMETER STYLE TD_GENERAL
	DETERMINISTIC
	LANGUAGE C
	EXTERNAL NAME 'CS!update_measures!update_measures.c!F!update_measures';
void update_measures (	
UDT_HANDLE     *thisUdt,
ARRAY_HANDLE   *aryval, 
INTEGER        *result,
char           sqlstate[6])
{
/* body function */
}