This site contains the documentation that is relevant to older WSO2 product versions and offerings.
For the latest WSO2 documentation, visit https://wso2.com/documentation/.

Query Result Export Sample

Note that WSO2 EI is shipped with the following changes to what is mentioned in this documentation:

  • <PRODUCT_HOME>/repository/samples/ directory that includes all Data Integration samples is changed to <EI_HOME>/samples/data-services/.
  • <PRODUCT_HOME>/repository/samples/resources/ directory that includes all artifacts related to the Data Integration samples is changed to <EI_HOME>/samples/data-services/resources/.

The operations "thousandFive" and "incrementEmployeeSalaryEx" are used in demonstrating the query result export functionality in a data service. The query used in "thousandFive" operation exports the a result value with the name "increment". This increment value is taken in as a parameter by the query in the "incrementEmployeeSalaryEx" operation.

The figure below shows the dbs fragment that defines this behaviour:

  • employeeByNumber(1002)
  • begin_boxcar()
  • thousandFive()
  • incrementEmployeeSalaryEx(1002)
  • end_boxcar()
  • employeeByNumber(1002)

The return values from the first "employeeByNumber()" call and the second have a difference of 1500, which is the amount incremented within the boxcarring session. The 1500 value is passed into "incrementEmployeeSalaryEx" operation by the "thousandFive" operation.Â