PI19722: IN RATIONAL DEVELOPER FOR SYSTEM Z (RDz), HOST VARIABLE IN EXEC SQL SELECT INTO STATEMENT RESULTS IN AMBIGUOUS REFERENCE WARNING

Rational Developer for System z 9.1.1
Rational Developer for System z Interim Fix 1 for 9.1.1
Rational Developer for System z Interim Fix 2 for 9.1.1
Rational Developer for System z Fix Pack 1 (9.1.1.1) for 9.1.1.
Rational Developer for System z Interim Fix 1 for 9.1.1.1
Rational Developer for System z Interim Fix 2 for 9.1.1.1
Rational Developer for System z Fix Pack 1 (9.1.1.2) for 9.1.1.
Rational Developer for System z Interim Fix 1 for 9.1.1.2
Rational Developer for System z Interim Fix 2 for 9.1.1.2
Rational Developer for System z Fix Pack 1 (9.1.1.3) for 9.1.1.
Rational Developer for System z Interim Fix 1 for 9.1.1.3
Rational Developer for System z Fix Pack 1 (9.1.1.4) for 9.1.1.
Rational Developer for System z Fix Pack 1 (9.1.1.5) for 9.1.1.
Rational Developer for System z Fix Pack 1 (9.1.1.6) for 9.1.1.
Rational Developer for System z Fix Pack 1 (9.1.1.7) for 9.1.1.
Rational Developer for System z Fix Pack 1 (9.1.1.8) for 9.1.1
Rational Developer for System z Fix Pack 9 (9.1.1.9) for 9.1.1

APAR status

• Closed as program error.

Error description

• In Rational Developer for System z (RDz), the use of host
  variable name in EXEC SQL SELECT INTO statement results in
  ambiguous reference warning. Here is an example:
  
    TESTPROC: PROCEDURE  OPTIONS (MAIN)   REORDER ;
  
   DCL 1 F1,
         3 XXX          FIXED DEC(10,2),
         3 YYY           FIXED BIN(10),
  
         3 ZZZ          CHAR(12);
  
   EXEC SQL SELECT
       - XXX,  ZZZ
       INTO
            :F1.XXX,                     <--ambiguous reference
            :F1.YYY,                     <--ambiguous reference
            :F1.ZZZ                       <--ambiguous reference
       FROM where_clause     group_by_clause;
   END TESTPROC;
  

Local fix

• n/a
  

Problem summary

• The SQL reference resolve fails to distinguish between different
  references with the same name, even if the references are
  qualified.
  

Problem conclusion

• Modified the SQL reference resolver to better handle qualified
  data references.
  
  The problem listed in this APAR has been resolved with
  IBM Rational Developer for System z V9.1.1.0 Refresh 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

• R911 PSY

     UP