Re: Size of a SQL result set

["Simon Coulter" <shc@xxxxxxxxxxxxxxxxx>]

Hello Rob,

You wrote:
>My problem was a packed number in the middle.  Seems that x'00' can
>determine the end of the field in a result set.

No.  That's sounds wrong.  If that's what is happening someone deserves an
APAR.  What about an integer field containing the value zero (e.g.,
x'0000') in the middle of a record?

It would seem that the Domino application is treating the array parameter
as a C-string, hence the x'00' terminator effect.

Why aren't you using real result sets (i.e., SET RESULT SETS CURSOR xxx)?

Write a small Java application that invokes the same stored procedure and
see if that also suffers the truncation.  If I get time I might play with
this.

Regards,
Simon Coulter.

--------------------------------------------------------------------
   FlyByNight Software         AS/400 Technical Specialists
   http://www.flybynight.com.au/

   Phone: +61 3 9419 0175   Mobile: +61 0411 091 400        /"\
   Fax:   +61 3 9419 0175   mailto: shc@flybynight.com.au   \ /
                                                             X
                 ASCII Ribbon campaign against HTML E-Mail  / \
--------------------------------------------------------------------