How to Create a Deployable Web Service Using a Multiple-instance Array › Create an EXCEXTFUN to Retrieve the Order Header and Order Details

Create an EXCEXTFUN to Retrieve the Order Header and Order Details

The function EEF RTV ORDER, EXCEXTFUN type, based over the Order Detail file takes an input parameter of an order number and returns order information as output parameters as follows:

• The order header is represented by a single-instance output parameter.
• The order detail lines are represented by a multiple-instance output parameter.

This section describes how to define the EXCEXTFUN to include parameter interface and action diagram business logic, including calls to other functions. After you complete the steps in this section, your Action Diagram should match these example screens:

Important! As a CA 2E developer, you need to understand the architectural distinction between the two mechanisms to manipulate array data, despite the ability to use a common structural definition:

• Data can exist and be modified in an array by using database functions (Create Object – CRTOBJ, Delete Object –DLTOBJ, Change Object – CHGOBJ, and Retrieve Object – RTVOBJ) based over the *Arrays file. However, this array data cannot be accessed by the *MOVE ARRAY function.
• Data can also exist and be modified in a multiple-instance array parameter (in the PAR context) and in the ARR context by using the *MOVE ARRAY function. However, that array data cannot be accessed by database functions (Create Object – CRTOBJ, Delete Object –DLTOBJ, Change Object – CHGOBJ, and Retrieve Object – RTVOBJ) based over the *Arrays file.

Note: The function EEF RTV ORDER (Order Detail) relies on four other internal functions, as listed in the following table.

You need to build the required internal functions and the external function EEF RTV ORDER (Order detail):

Note: The file the functions is based over is shown in parentheses.

Follow these steps:

1. RTV Order Header (Order Header)
2. RTV Order Detail (*Arrays)
3. CRT Order Detail (*Arrays)
4. Load Order Detail Array (Order detail)
5. EEF RTV Order (Order detail)