At 06:27 AM 22/06/2004 -0700, you wrote:

>Thanks so much Helen - greatly appreciated.
>One question: I need to remove the suspend; from the SP? I thought I needed
>this whenever returning a value. Apparently just for a record set?

Yes. SUSPEND is needed when the SP is pushing rows out to a buffer. It
literally does *suspend* the SP, which waits for the caller to fetch the
row it just created.

Executable procs push their singleton result set directly into the XSQLDA
structure - a one-off that happens when execution reaches the final END
statement. In an executable procedure, SUSPEND means the same as EXIT, i.e.
it causes the SP to stop executing.

Helen