Table of Contents

Search

  1. Preface
  2. Welcome to Informatica Process Developer
  3. Using Guide Developer for the First Time
  4. Getting Started with Informatica Process Developer
  5. About Interfaces Service References and Local WSDL
  6. Planning Your BPEL Process
  7. Participants
  8. Implementing a BPMN Task or Event in BPEL
  9. Implementing a BPMN Gateway or Control Flow
  10. Using Variables
  11. Attachments
  12. Using Links
  13. Data Manipulation
  14. Compensation
  15. Correlation
  16. What is Correlation
  17. What is a Correlation Set
  18. Creating Message Properties and Property Aliases
  19. Adding a Correlation Set
  20. Deleting a Correlation Set
  21. Adding Correlations to an Activity
  22. Rules for Declaring and Using Correlation Sets
  23. Correlation Sets and Engine-Managed Correlation
  24. Event Handling
  25. Fault Handling
  26. Simulating and Debugging
  27. Deploying Your Processes
  28. BPEL Unit Testing
  29. Creating POJO and XQuery Custom Functions
  30. Custom Service Interactions
  31. Process Exception Management
  32. Creating Reports for Process Server and Central
  33. Business Event Processing
  34. Process Central Forms and Configuration
  35. Building a Process with a System Service
  36. Human Tasks
  37. BPEL Faults and Reports

2. Designer

2. Designer

Examples

Examples

Example of running a stored procedure on a MySQL database
<das:multiDataAccessRequest xmlns:das= "http://schemas.active-endpoints.com/data-access /2010/04/data-access.xsd"> <das:sqlStatement columnCase="uppercase" statementId="create-proc"> <das:statement>CREATE PROCEDURE AeTestCount(OUT result INT) BEGIN SELECT COUNT(*) INTO result FROM AeJUnitTestTable; END </das:statement> </das:sqlStatement> <das:sqlStatement columnCase="uppercase" statementId="call-proc"> <das:statement>CALL AeTestCount(@rowCount);</das:statement> </das:sqlStatement> <das:sqlStatement columnCase="uppercase" statementId="get-results"> <das:statement>SELECT @rowCount;</das:statement> </das:sqlStatement> <das:sqlStatement columnCase="uppercase" statementId="drop-proc"> <das:statement>DROP PROCEDURE AeTestCount</das:statement> </das:sqlStatement> </das:multiDataAccessRequest>
Example of running a stored procedure on an SQL Server database
<das:multiDataAccessRequest xmlns:das= "http://schemas.active-endpoints.com/ data-access/2010/04/data-access.xsd"> <das:sqlStatement columnCase="uppercase" statementId="create-proc"> <das:statement>CREATE PROCEDURE AeTestCount @num_rows INT OUTPUT AS BEGIN SELECT @num_rows = COUNT(*) FROM AeJUnitTestTable END </das:statement> </das:sqlStatement> <das:sqlStatement hasResultSet="true" columnCase="uppercase" statementId="call-proc"> <das:statement>DECLARE @result INT EXEC AeTestCount @num_rows = @result OUTPUT SELECT @result RESULT </das:statement> </das:sqlStatement> <das:sqlStatement columnCase="uppercase" statementId="drop-proc"> <das:statement>DROP PROCEDURE AeTestCount</das:statement> </das:sqlStatement> </das:multiDataAccessRequest>
Example of running a stored procedure on an Oracle database
<das:multiDataAccessRequest xmlns:das="http://schemas.active-endpoints.com/ data-access/2010/04/data-access.xsd"> <das:sqlStatement columnCase="uppercase" statementId="create-proc"> <das:statement>create or replace PROCEDURE AeTestCountProc (PROP_NAME IN VARCHAR2, PROP_VAL IN VARCHAR2, TOTAL OUT NUMBER) AS BEGIN UPDATE AeMetaInfo SET PropertyValue = PROP_VAL WHERE PropertyName = PROP_NAME; SELECT COUNT(*) INTO TOTAL FROM AeJUnitTestTable; END; </das:statement> </das:sqlStatement> <das:sqlStatement columnCase="uppercase" statementId="call-proc"> <das:statement>{CALL AeTestCountProc(?,?,?)}</das:statement> <das:procedure> <das:parameter name="PROP_NAME" sqlType="string" mode="in">BogusName</das:parameter> <das:parameter name="PROP_VAL" sqlType="string" mode="in">BogusValue</das:parameter> <das:parameter name="RESULT" sqlType="int" mode="out" /> </das:procedure> </das:sqlStatement> <das:sqlStatement columnCase="uppercase" statementId="drop-proc"> <das:statement>DROP PROCEDURE AeTestCountProc</das:statement> </das:sqlStatement> </das:multiDataAccessRequest>


Updated March 30, 2020