PM65850: Ambiguous reference warning for EXEC SQL statements when preference "Validate database references" is enabled.

APAR status

• Closed as program error.

Error description

• An "Ambiguous reference" warning icon appears next to EXEC SQL
  statements when editing a COBOL or PL/I source containing EXEC
  SQL DECLARE TABLE statements if the "Validate database
  references" preference is enabled (Window > Preferences > Data
  Management > SQL Development > EXEC SQL Statements).
  

Local fix

• n/a
  

Problem summary

• The real-time syntax check phase for "Validate database
  references" on SQL statements can sometimes miss references to
  tables declared within the compilation unit using EXEC SQL
  DECLARE TABLE statements.  This can result in unexpected
  "Ambiguous reference" or "Unresolved reference" warnings within
  EXEC SQL statements.
  

Problem conclusion

• References to tables declared within the compilation unit using
  EXEC SQL DECLARE TABLE statements can sometimes be left out of
  the database symbol table, resulting in unexpected "Ambiguous
  reference" or "Unresolved reference" warnings within EXEC SQL
  statements.  The database reference validation needs to correct
  the finding of DECLARE TABLE references.
  
  The problem listed in this APAR has been resolved with
  IBM Rational Developer for System z V8.0.3.3 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