Sender DB2 SP with input Param and a following delete statement

[former_member185846]

Dear Experts,

I need to call a DB2 stored procedure in the sender adapter along with an input param, which describes the number of rows to be read. Please provide me the syntax for the same.

Also, is it possible to execute an update/delete statement after the SP is called as we do for regular Select query instead of SP?

Thanks,

Message was edited

[baskar_gopalakrishnan2]

You might want to see this thread and see if that helps.

http://scn.sap.com/thread/528312

[MichalKrawczyk]

Hi,

ALTERNATIVE:

in case you'd need to call an SP without any limitations (like one select in it)

you can always create your own adapter as I did for that with relatively not a lot of effort:

http://scn.sap.com/community/pi-and-soa-middleware/blog/2011/10/04/pixi-sender-jdbc-adapter-for-orac...

Regards,

Michal Krawczyk

[former_member185846]

Thanks for the details, Mike. But, we got a change request after our code freeze and we don't have much time to make such changes now. So, please clarify whether can I use a delete statement in the Update option after a SP execution?

[MichalKrawczyk]

hi,

>>>>So, please clarify whether can I use a delete statement in the Update option after a SP execution?

AFAIK - should work but don't have any PI system with SP procedure to check right now,

but I'd say it will work anyway

Regards,

Michal Krawczyk