Call DB2 stored procedure

Post questions here relative to DataStage Enterprise/PX Edition for such areas as Parallel job design, Parallel datasets, BuildOps, Wrappers, etc.

Moderators: chulett, rschirm, roy

Post Reply
goffinw
Participant
Posts: 27
Joined: Thu Nov 18, 2004 6:50 am
Location: Belgium

Call DB2 stored procedure

Post 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
Post Reply