Data360 Analyze

 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.