Array result sets problem

["Suresh kumar BV" <suresh@xxxxxxxxxxxxxxxxxx>]

Hi all,
  We have written a stored procedure in ILE RPG to return an array result
set. In Java when we tried to acces the result set we get a type mismatch
error. IBM Redbook provides examples where one can pass back & forth cursor
result sets. I did not come across any example with Java client program
handling array result set sent by a stored procedure. In RPG, as per IBM,
we are defining a  multiple occurance DS and send it back with the SET
RESULT SETS ARRAY :<MDS name> for :<index> ROWS. Where is the problem? Can
somebody post a small sample program showing both stored procedure
(preferably in RPG) and client program (in Java)?
Thanx in advance
Suresh

Antares Systems Ltd.
# 24, Sudha Complex, 3rd Stage, 4th Block,
Basaveshwaranagar,
Bangalore - 560 079
Telefax : 91-80-3284311, 3284313