IBM Support

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

Subscribe

You can track all active APARs for this component.

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 number

    PI19722

  • Reported component name

    RATL DEV FOR SY

  • Reported component ID

    5724T0700

  • Reported release

    851

  • Status

    CLOSED PER

  • PE

    NoPE

  • HIPER

    NoHIPER

  • Special Attention

    NoSpecatt

  • Submitted date

    2014-06-10

  • Closed date

    2014-12-11

  • Last modified date

    2014-12-11

  • 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



Document information

More support for: Rational Developer for System z

Software version: 851

Reference #: PI19722

Modified date: 11 December 2014