OEXTEND - Teradata Vantage NewSQL Engine - 16.20

Teradata Vantageā„¢ Data Types and Literals

prodname
Teradata Database
Teradata Vantage NewSQL Engine
vrm_release
16.20
category
Programming Reference
featnum
B035-1143-162K

Purpose

Allocates space for one or more new elements in array_expr.

Syntax

System Function

Method-Style

TD_SYSFNLIB.
Name of the database where the function is located.
array_expr
An ARRAY expression, which is one of the following:
  • A reference to an ARRAY column
  • An ARRAY constructor expression
  • A UDF expression
  • A UDM expression
num_spaces
An optional unsigned integer value representing the number of NULL elements to append to array_expr.
index_value
An optional unsigned integer value used as an index to an element in array_expr.
array_bound

An array instance of the predefined array type ArrayVec with a comma-separated list of integer values to define the bounds.