db2 stored procedure

  1. E9.1 F3111 Parts List in a Stored Procedure

    Hi All I'm not sure if it is possible but I'll ask the question anyway ! The request is, for every F4801 WO, read all corresponding F3111 Parts List records and if any of those records don't have enough available qty, then summarize as "Inventory Short". So the output would be one row per WO...
  2. E9.2 Using Orchestrator versus DB2 Stored Procedures to extract data from JDE

    Hi The company I work for currently has E9.10 and is in the process of upgrading to E9.20. An outside company created a web application to (currently) show orders/statuses etc for our customers. We've created DB2 stored procedures to extract the required data for that company to build into...
  3. E1 application or BSFN calling DB2 stored procedure on iSeries

    I am trying to find a way to call a DB2 stored procedures from an E1 BSFN passing input parameters and consuming multiple return parameters grouped in one record set (multiple records) E1 910 residing on a AIX Unix Box DB2 Stored procedure residing on iSeries box Does anyone have any...
Top