Arrays in Stored Procedure

Hi,
I have stored procedures in DB2 UDB for AIX Unix environment. I need to accept arrays as input parameter. What is the syntax to declare them?I am unable to located the syntax anywhere in IBM site. Is it possible to have arrays at all?

Nag_G

See if you can use table functions in your processing.

nag_gopalakrishnan-at-glic.com wrote:
> Hi, I have stored procedures in DB2 UDB for AIX Unix environment. I
> need to accept arrays as input parameter. What is the syntax to
> declare them?I am unable to located the syntax anywhere in IBM site.
> Is it possible to have arrays at all?

Not in any released version of DB2.

The next release of DB2 ("Viper 2") is slated to provide this support,
but we'll see when it's officially announced.

What do you mean by table processing functions?

nag_gopalakrishnan-at-glic.com wrote:

> What do you mean by table processing functions?

In true relational fashion (not very nice sometimes for the developer), you
would store the data in a table (or temp table), then call the procedure,
and the procedure queries the table to get the data.

--
Knut Stolze
DB2 z/OS Utilities Development
IBM Germany