Array data type in Triggers

[rdpratti]

Hi,
I am coding Java and C Stored procedures for DB2 LUW 9.5. I read with
interest
about the availability of arrays as parameters to stored procedures.

Is there a way within a trigger to build an array to pass to a stored
procedure?

Thanks,

- rd

[Serge Rielau]

Re: Array data type in Triggers

rdpratti wrote:

Hi,
I am coding Java and C Stored procedures for DB2 LUW 9.5. I read with
interest
about the availability of arrays as parameters to stored procedures.
>
Is there a way within a trigger to build an array to pass to a stored
procedure?

Presently not.
ARRAY support in DB2 9.5 has been aimed at SQL stored procedures and
their invocation from JDBC and CLI

I'm interested in your use case as it helps prioritize whenether/when to
extend support.

Cheers
Serge
--
Serge Rielau
DB2 Solutions Development
IBM Toronto Lab

[rdpratti]

Re: Array data type in Triggers

On Jan 9, 2:42 pm, Serge Rielau <srie...@ca.ibm .comwrote:

rdpratti wrote:

Hi,
I am coding Java and C Stored procedures for DB2 LUW 9.5.  I read with
interest
about the availability of arrays as parameters to stored procedures.

>

Is there a way within a trigger to build an array to pass to a stored
procedure?

>
Presently not.
ARRAY support in DB2 9.5 has been aimed at SQL stored procedures and
their invocation from JDBC and CLI
>
I'm interested in your use case as it helps prioritize whenether/when to
extend support.
>
Cheers
Serge
--
Serge Rielau
DB2 Solutions Development
IBM Toronto Lab

Thanks for the input, Serge. I provided some reuqirements input to you
directly.
- rd