Passing a java array in to a DB2 stored procedure

[Eugene]

Hi All,

I am having a hard time figuring out how to pass a ("true") java
array, like int[], from a jdbc application in to a DB2 stored
procedure or UDF (can be a java or SQL proc or a table UDF). Having
the application to write the array to a DB2 global temp table, or
passing it in any surrogate form like delimited string (or a byte
stream) of elements, are not possible alternatives. Is that
implementable at all with DB2 jdbc? (I am using DB2 UDB 8.1.4 for
Linux)

Thanks,
-Eugene

[Serge Rielau]

Re: Passing a java array in to a DB2 stored procedure

Eugene,

I don't think there is an alternative, although I'm no JDBC expert.
Can you elaborate on why a temp table is not an option?

Cheers
Serge
--
Serge Rielau
DB2 SQL Compiler Development
IBM Toronto Lab