Release 2.1

Application: SQL/00

7/14/99

Requirements

This is release 2.1 of the APPX SQL/00 application, which is shipped with APPX.

Problem Description, ECR #4795

The Query process generated by the SQL application contains ILF code in the PRE-USER SELECT event point for "Calculations" defined in the SQL query. This ILF code was missing the OVERFLOW statement to handle overflow situations and could thus result in the Query process crashing rather than handling the overflow. This problem is corrected in this release.

Instructions

  1. Backup your SQL/00 application.

  2. For your SQL/00 application:
    Scratch the Em Directory
    Scratch the Dbg Directory

  3. Retrieve one of the following files:
    ftp://ftp.appx.com/pub/sql/SQL21-ris.tgz for risc systems
    ftp://ftp.appx.com/pub/sql/SQL21-int.tgz for Intel systems

  4. Uncompress the file and extract it into your APPXPATH directory. This will replace your SQL/00 application.

  5. New queries created with the SQL application should correctly have the OVERFLOW statement generated. Existing queries will have to be selected, changed in some way, and re-saved so that the OVERFLOW statement can be generated.