Update Processes

Item 11.1

Bug (supposed to be fixed in APPX 3.0.0): APPX 1.8.4 can sometimes skip the PCF record if it is being held and there is no explicit code to read the record with hold.

Item 11.2

Action/Difference: APPX requires a higher level PCF record be read with hold before being rewritten or deleted at a lower level whereas SP2 does not. This will cause an error at runtime. Check APPX ILF X-Ref for use of REWRITE or DELETE in lower level output and investigate. You can also use the APPX Software, Inc. UTL CS utility "APPX STMT I/O List" to review REWRITE/DELETE commands. (See item 10.5.)

Item 11.3

Bug (flagged in V05): In APPX 3.0.0, the action log for an Update process does not print any ERROR or WARNING messages issued in End of Process. However, it does print those issued in Start of Process. Unexpected type ERROR's (like those following READ's or WRITE's) can probably be ignored but any messages that provide needed information of some kind will require alternative programming. If the update process uses a query, one solution would be to modify the query as needed to have STANDARD grand totals with 'Editable?'="N" (be sure to check the X-ref for other use of the query), add an unbounded RANGE-END frame as needed to the update, and move the necessary code to this frame from End of Process.

Item 11.4

Difference (flagged in V05): SP2 allows a total-type work field to be used as an ordinary work field in the detail window of an output/update function and sets the value to zero before entering the detail window. There is no such thing as a total-type work field in APPX (see explanation in item 8.13) and APPX does not change the current area of a numeric work field without explicit commands to do so. If code exists in a detail window which relies upon the zero value, the SP2 total-type work field must be SET to zero at the beginning of the event point in APPX. In addition, there are other complications if commands are used on a SP2 total-type work field in a subtotal window (see item 8.13).

The conversion log flags the use of commands such as SET, COMPUTE, and RESTORE on SP2 total-type fields. (See items 8.13 & 10.23.)

Item 11.5

Bug?/Difference: If a query has a temporary file as its PCF and if the temporary file is populated in the job after the QUERY job step, an update using the query may not find the populated file when the job is run in background. (See item 12.11.)