Here is an example stored procedure configuration. You first need to select a database instance and table name, in order for Cloverleaf to parse the message sent to the outbound thread. Cloverleaf will make the message comma delimited, and each comma-delimited field will represent a column in the database table. This should have been created first in the database schema configurator.
The items in the stored procedure parameter list will correspond to the values in the outbound message. Behind the scenes it creates a VRL for the table. The VRL is used in your translate on the inbound thread. And you use the VRL field names in the S.P. call statement below. You don’t need to include all the columns/fields in your S.P. call, just the fields you want, as long as you use the correct field names.
In this example, the stored procedure name is ‘prPRL_insertMsg’.
{call prPRL_insertMsg(,,, , , )}
You will need the brackets and parenthesis. Don’t forget to set the security access for the stored procedure.
Peter Heggie
PeterHeggie@crouse.org
.
