B2B Integration

 View Only
Expand all | Collapse all

Calling MS SQL stored procedures with output parameters from IBM ITX map using JDBC driver

  • 1.  Calling MS SQL stored procedures with output parameters from IBM ITX map using JDBC driver

    Posted Thu March 17, 2022 01:40 AM
    Hi Team, 

    Could you please suggest if there is any way to call MS SQL stored procedure using JDBC adapter from ITX Map. I am trying to call stored procedure that has output parameters and scalar output. 

    Regards
    Rao

    ------------------------------
    AnkammaRao Cherala
    ------------------------------

    #B2BIntegration
    #SupplyChain


  • 2.  RE: Calling MS SQL stored procedures with output parameters from IBM ITX map using JDBC driver

    Posted Thu March 17, 2022 01:58 AM
      |   view attached
    Check out this one.  It uses DB2.
    You need V10 to import the project as it's built in V10.


    ------------------------------
    Rex Chan
    ------------------------------

    Attachment(s)

    zip
    DB2_SP.zip   40 KB 1 version


  • 3.  RE: Calling MS SQL stored procedures with output parameters from IBM ITX map using JDBC driver

    Posted Fri March 18, 2022 06:22 AM
    Thank you very much Rex. I was trying to find solution to call a stored procedure that has OUTPUT arguments. If possible, could you please share the same.

    Regards
    AnkammaRao

    ------------------------------
    AnkammaRao Cherala
    ------------------------------