Figure 3-5 Client Access server setup

10.After you make all necessary changes, click Apply and then click OK.

As an alternative, you can perform these steps:

1.Open Operations Navigator.

2.Sign on as OMUSER.

3.Expand the iSeries.

4.Right-click the database and select Run SQL Scripts.

5.Open the /OrderManagement/Stored Procedures folder.

6.Double-click the script to select it.

7.Change the parameters as indicated in the previous set of instructions.

The scripts all start with a DROP PROCEDURE instruction. This removes any previously installed stored procedures. However, this does not run the first time the scripts start. In this case, position the cursor on the second line of the script. Then select Run-> From Selected.

Other SQL

Some static data must be set up. You achieve this by running the SQL scripts in the SQL Scripts folder. Use the Client Access SQL tool as explained in the previous section and run all the scripts in this folder.

3.2.5 Java Message Service

JMS is used to send messages from the server to the client. It is used when, for example, there are supply problems or the order is suspended. It is also used to allow complex time consuming steps to be completed asynchronously, for example when the order is written to System21.

Ensure that WebSphere is started.

Chapter 3. Installing and setting up call.connect 31

Page 43
Image 43
IBM SG24-6526-00 manual Java Message Service, Other SQL, Open the /OrderManagement/Stored Procedures folder