Stored procedures can return result code which is distinct from OUT
parameters. Example:
db2 => call postgres.tpcbprofile(1,1,1,15)

Stav při návratu = 540

Is there way to get this return code via JDBC API?

On Aug 28, 11:18Â*am, hsn_ <kolar.ra... (AT) gmail (DOT) com> wrote:
Hi, I'm typing this from memory, before I've fully woken up,
so do check the details of the syntax, but this is close...

CallableStatement cs = c.prepareCall("{ ? :=
postgres.tpcbprofile(1,1,1,15) }");
cs.registerOutParameter(1, INT );
cs.execute();
int foo = cs.getInt(1);

Joe Weinstein

On Aug 30, 7:48Â*am, "joeNOS... (AT) bea (DOT) com" <joe.weinst... (AT) gmail (DOT) com>
wrote:
It's
CallableStatement cs = c.prepareCall("{ ? =
postgres.tpcbprofile(1,1,1,15) }");
cs.registerOutParameter(1, java.sql.Types.INTEGER );
cs.execute();
// first process any 'inline' returns first, such as update counts and
resultsets, if any
// Then:
int foo = cs.getInt(1);