IBM Support

PK77826: SQL PROGRAMS GENERATED IN RATIONAL BUSINESS DEVELOPER V7.1.0.1 A RE RECEIVING A -407 ON AN INSERT STATEMENT.

Subscribe

You can track all active APARs for this component.

 

APAR status

  • Closed as program error.

Error description

  • EGL programs migrated from VisualAge Generator and running in CI
    CS may receive an SQL error -407 on executing an insert statemen
    t.
    
    COBOL gen has a bug when the right side of an SQL expression has
     more than 1 item. COBOL gen should be resetting the null flag,
    instead of processing it.
    

Local fix

Problem summary

  • In VAGen, when an expression of more than 1 item is being
    assigned to a target, then VAGen did not use the sqlnullable
    flag of the source, but instead just reset the target's
    sqlnullable flag if present. EGL was paying attention to the
    source's flag. This has been fixed.
    

Problem conclusion

  • Software updated
    

Temporary fix

Comments

APAR Information

  • APAR number

    PK77826

  • Reported component name

    RATL BUS DEV

  • Reported component ID

    5724S5000

  • Reported release

    700

  • Status

    CLOSED PER

  • PE

    NoPE

  • HIPER

    NoHIPER

  • Special Attention

    NoSpecatt

  • Submitted date

    2008-12-19

  • Closed date

    2009-03-20

  • Last modified date

    2009-03-20

  • 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 BUS DEV

  • Fixed component ID

    5724S5000

Applicable component levels

  • R700 PSN

       UP

[{"Business Unit":{"code":"BU058","label":"IBM Infrastructure w\/TPS"},"Product":{"code":"SSMQ79","label":"Rational Business Developer"},"Component":"","ARM Category":[],"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"7.0","Edition":"","Line of Business":{"code":"LOB35","label":"Mainframe SW"}}]

Document Information

Modified date:
20 March 2009