Cannot see stored procedures in Database tab on B2B Integration Server

I am trying to map from the pipeline to parameters of a stored procedure. However I cannot see any stored procedures in the database tab on the B2B Integration Server in order to generate a service. I can only see Tables and Views. I can invoke the stored procedure but I can only enter data via $data. Works fine but I want to map. Any ideas?
Barry Runyon

Barry,

I’m assuming your using the pub.db:call service from WmDB? If so, $data is a record structure. Just create strings underneath it representing the various parameters your stored procedure expects. Then map what you’ve got in pipelineIn to the new structure under $data.

Just make sure you map before saving or refreshing, or the Developer removes your structure automatically.