Array data type in Triggers

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

rdpratti - 09 Jan 2008 10:22 GMT

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

Reply to this Message

Serge Rielau - 09 Jan 2008 19:42 GMT

> Hi,
> I am coding Java and C Stored procedures for DB2 LUW 9.5. I read with
[quoted text clipped - 3 lines]
> 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

Signature

Serge Rielau
DB2 Solutions Development
IBM Toronto Lab

Reply to this Message

rdpratti - 14 Jan 2008 18:00 GMT

> > Hi,
> > I am coding Java and C Stored procedures for DB2 LUW 9.5. I read with
[quoted text clipped - 17 lines]
> DB2 Solutions Development
> IBM Toronto Lab

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

Reply to this Message