Arrays in Stored Procedure

[n***@glic.com]

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

[s***@computer.org]

See if you can use table functions in your processing.

[n***@glic.com]

What do you mean by table processing functions?

[Knut Stolze]

Post by n***@glic.com
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.

[Ian]

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.