SQL statement details of a web service provider method
In the SQL statement of a web service provider method, any SQL statement is allowed (SELECT, INVOKE, UPDATE, DELETE, INSERT).
For SELECT and INVOKE statements, the output parameters are generated automatically when you click the Check button, and choose for generating new parameters. These output parameters are generated from the column expressions that occur in the SELECT clause.
In the case of an INSERT, DELETE, or UPDATE statement, since these statements have no output columns, output parameters are not generated automatically.
If you want to provide the functionality of an INSERT/DELETE/UPDATE statement, and also report back to the client (send output parameter values to the caller of the web service provider), you can use the XML import method or a USoft Batch job with output parameters.
When using the XML import method, you can use the returning XML document and transform it to match the required web service output. For more details, refer to: The XML Import method, and: The returning XML document.
When using a USoft Batch job with output parameters, you can create a job with an output parameter set, and a SQL task or Import task that performs the INSERT/UPDATE/DELETE statement, and then fill the output parameter(s) of the job with the required web service output. In the SQL statement of the web service method, you can then call the BatchRunner component. Use those methods that support output parameters.