IBM PureData System for Analytics, Version 7.1

The element_name() and nelement_name() functions

The element_name() and nelement_name() functions return the name of an element if it exists.

Description

The element_name() function has the following syntax:

varchar = element_name(array input, int index);

The nelement_name() function is the Unicode form of the function and has the following syntax:

nvarchar = nelement_name(array input, int index);

The input value specifies the array which contains the named element.

The index value specifies the element for which to retrieve the name.

For example:

select element_name(add_element(array(4),4,'Netezza'),1);

This example returns the element name of index 1:

 element_name 
--------------
 Netezza
(1 row)