array in db2 using Java

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

aaron80v@yahoo.com.au - 11 Apr 2007 17:01 GMT

Hi,

Currently I am embarked on a project that requires me to define and
pass array to stored procedure, and I found out that there is no
direct way to do this. I wonder if a combination of UDF and java code
should be able to accomplish this. Has anyone accomplish this before?
Maybe someone can share the best way to accomplish this. I am using
DB2 8.1. I am sure someone has done it before, I just need a guideline
how to do this best.

Aaron.

Reply to this Message

Knut Stolze - 11 Apr 2007 18:31 GMT

> Hi,
>
[quoted text clipped - 5 lines]
> DB2 8.1. I am sure someone has done it before, I just need a guideline
> how to do this best.

No clue what you really want to do. But you could simply write the data
into a table, call the procedure and the procedure reads from the table.
The table can be a temp table.

Signature

Knut Stolze
DB2 z/OS Utilities Development
IBM Germany

Reply to this Message

aaron80v@yahoo.com.au - 12 Apr 2007 13:17 GMT

> aaron...@yahoo.com.au wrote:
>
[quoted text clipped - 16 lines]
> DB2 z/OS Utilities Development
> IBM Germany

My intention is simple. The workaround using temp table is not an
option. What I need is to be able to define an array in Java, get the
resultset and store it in array and pass this array on to stored
procedure. Isn't there any JDBC side API catered for this? I have been
doing varray (Oracle) all the while and would like to mimic the same
functionality in DB2. We have Java folks but we are not totally
familiar with DB2. So any guide will be appreciated.

Aaron.

Reply to this Message

Serge Rielau - 12 Apr 2007 17:05 GMT

>> aaron...@yahoo.com.au wrote:
>>
[quoted text clipped - 24 lines]
>
> Aaron.

Aaron, did you get may email?

Cheers
Serge

Signature

Serge Rielau
DB2 Solutions Development
IBM Toronto Lab

Reply to this Message

aaron80v@yahoo.com.au - 13 Apr 2007 01:40 GMT

> aaron...@yahoo.com.au wrote:
> >> aaron...@yahoo.com.au wrote:
[quoted text clipped - 35 lines]
> DB2 Solutions Development
> IBM Toronto Lab

Yes I did. Thanks.

Aaron

Reply to this Message