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
- Former user (Deleted)
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.Â