Page 1 of 1

Call DB2 stored procedure

Posted: Thu Mar 06, 2008 8:33 am
by goffinw
Using the DB2 API Stage,
  • I can call a stored procedure instead of upserting: SQL "call apply_rechtstoestand (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?);"
    I cannot define a reject link.
Using the DB2 Enterprise Stage,
  • I can define a reject link.
    I cannot call a stored procedure.
Is there any way to call DB2 stored procedures AND to define a reject link?
If not, does anyone have an approach for 'rejects handling', in case I use a stored procedure to apply data to a DB2 database?

Thanks in advance,
Wim