Array in HANA

[Former Member]

Hi,

I need to work with an Arraay in HANA SQL Script. Is this possible? How can I define an array in HANA?

Is it possible to use array as input parameter?

Thank you in advance.

[Former Member · Accepted solution]

Hi,

An array is an indexed collection of elements of a single data type. In the following section we explore the varying ways to define and use arrays in SQLScript.

Syntax

ARRAY(<value_expression> [{, <value_expression>}...])

Syntax Elements

<value_expression> ::= <string_literal> | <number>

The array can contain strings or numbers.

Description

The ARRAY function returns an array whose elements are specified in the list of value expressions.

Regards

NK

[Former Member · Accepted solution]

Hi Naveen,

I have below requirement. How i should process with array.

Requirement

===================

Below is my requirement.

From UI i am getting three input parameters.

1) First input parameter is array which is containing columns of existing view.

2) Second parameter is also an array which is containing columns of existing view.

3) Third parameter containing name of existing view.

Above two array containing columns of existing view.Name of view is passed in third parameter.

Now i need to send data through procedure by selecting columns from view. All array value will be char. How i should pass the data from procedure as columns are dynamic? for example --

If first array containing column as name,id and second array containing column as firstname,lastname and third parameter containing view name as ABC.Then i need to return data by writing select name,id,firstname,lastname from ABC. all these data need to pass through procedure.

If some another way of doing above requirement,then please do let me know.

Please help.