PM74644: Rational Developer for System z (RDz) COBOL Editor SQL statement flagged as error when lowercase used

APAR status

• Closed as program error.

Error description

• Rational Developer for System z - RDz - v8.0.3.3
  
  Valid SQL statement is incorrectly flagged in error.  The error
  'Unable to resolve reference' is issued when the following
  statement has sorteer in lowercase:
   DECLARE CURSOR-LOCATIONS CURSOR FOR
                 SELECT LOCATION
                       ,PORT
                       ,DBALIAS
                       ,CASE
                         WHEN LOCATION = :LOCATION
                           OR LOCATION = :DBALIAS
                           OR LOCATION = :PORT
                              THEN 1
                         WHEN LOCATION = :DBALIAS
                              THEN 2
                         ELSE
                                   3
                        END AS sorteer
                   FROM SYSIBM.LOCATIONS
                 WHERE  TPN = :TPN
                 ORDER BY sorteer ASC
               END-EXEC
  
  ***************************************************************
  Local fix:
  Use uppercase for variables such as SORTEER instead of sorteer
  

Local fix

Problem summary

• "Unresolved reference to [column-name]" annotation message
  appears for a result column created by an AS clause in a SELECT
  statement, when the result column is specified in lower- or
  mixed-case.
  

Problem conclusion

• Result columns were being added to the internal symbol table in
  the case they were first mentioned, so the reference resolving,
  which depends on uppercase symbol names, could not find the
  result columns.    The fix is to make sure symbols are added to
  the internal symbol table in uppercase.
  
  The problem listed in this APAR has been resolved with
  IBM Rational Developer for System z V8.0.3.4 Fix Pack which
  is available from the Recommended Fixes support download page:
  http://www-1.ibm.com/support/docview.wss?rs=2294&uid=swg27006335
  

Temporary fix

Comments

APAR Information

• APAR is sysrouted FROM one or more of the following:

• APAR is sysrouted TO one or more of the following:

Fix information

• Fixed component name

  RATL DEV FOR SY

• Fixed component ID

  5724T0700

Applicable component levels

• R803 PSY

     UP