Procedure
- In IBM Integration Toolkit, right-click the
Stored_Procedures application, and then select Test. The test client opens.
- Right-click the Body table and click Add Message
Part.
- From the Type Selection, select Employee and click
OK. The message body opens as an XML structure.
- In the Value column, change the default value (EMPL_NUM) to the number
000070.
- Click Send Message.
- Confirm the deployment to the default Integration Server and click Next.
- Optional: On the next screen, increase the default wait time for deployment to
120, and then click Finish.
It can take a couple of seconds for the call to complete and display the response from the
database with the details for the employee with number 000070.
Tip: If you do not see the expected output, review any event log error message from the
IBM Integration Bus. You might need to restart integration
node IB9NODE to ensure the JDBC configurable service and database security settings are being picked
up.
- Optional: To rerun the test with a different serial number, right-click Invoke Message
Flow and select Duplicate.
- Change the entry in the Value field to 10, and
then click Send Message.
Results
You have successfully completed this scenario.