IBM webMethods Hybrid Integration

IBM webMethods Hybrid Integration

Join this online group to communicate across IBM product users and experts by sharing advice and best practices with peers and staying up to date regarding product enhancements.


#TechXchangePresenter
 View Only
Expand all | Collapse all

Cannot see stored procedures in Database tab on B2B Integration Server

  • 1.  Cannot see stored procedures in Database tab on B2B Integration Server

    Posted Tue January 21, 2003 03:06 PM

    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


    #Flow-and-Java-services
    #webMethods
    #Integration-Server-and-ESB


  • 2.  RE: Cannot see stored procedures in Database tab on B2B Integration Server

    Posted Tue January 21, 2003 08:32 PM

    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.


    #Integration-Server-and-ESB
    #webMethods
    #Flow-and-Java-services