Data360 Analyze

Welcome to the Data360 Analyze community!  Please feel free to start a discussion in the discussion tab or join in a conversation.

Here are some useful links where you can find more information:

Product Announcements  Product Documentation  Ideas Portal

Discussions

Members

Resources

Events

 View Only

  • 1.  Stored Procedures directly from Database

    Posted 10-22-2020 13:45

    Hi Infogix,

    Does Data360 support running Stored Procedures directly from Database? Are there any nodes which can be helpful? 

    Example of Stored Procedure:
    Exec[usp_EDR_DERIVATIVE_SUMMARY_RPT] 1, '2020-01-31', @PAGESIZE = 600000



  • 2.  RE: Stored Procedures directly from Database

    Employee
    Posted 10-26-2020 04:06

    The JDBC Query and JDBC Execute nodes use a user-defined SQL script. You can include statements in yout script that can invoke stored procedures. Typically, the script leverages SQL query field bindings to parameterize the operation of the node, for example:

     

    The actual statements used will depend on the SQL dialect used by the target RDBMS.