IBM Support

PI58178: SQLCODE -311 RECEIVED WHEN RUNNING PROC IN NON-ENGLISH ENVIRONME NT

A fix is available

Subscribe

You can track all active APARs for this component.

 

APAR status

  • Closed as program error.

Error description

  • SQLCODE -311 received when running PROC in non-English environme
    nt
    

Local fix

Problem summary

  • ****************************************************************
    * USERS AFFECTED: All QMF for TSO/CICS users who use QMF       *
    *                 installations other than English -- NLS      *
    *                 customers.                                   *
    ****************************************************************
    * PROBLEM DESCRIPTION: A non-English installation of QMF       *
    *                      can receive SQLCODE -311 if users       *
    *                      run a PROC that calls a QUERY           *
    *                      that performs an INSERT or other        *
    *                      nonretrieval statement.                 *
    ****************************************************************
    * RECOMMENDATION:                                              *
    ****************************************************************
    If the global variable DSQEC_NLFCMD_LANG is set to 1, the RUN
    command is stored as "RUN" in a QMF control block, rather than
    the national language translation for the RUN command. QMF code
    compared the value for RUN in the control block with the
    translated version of RUN.  If they did not match, QMF took an
    unintended code path with uninitialized variabes that led to
    the SQLCODE -311.
    

Problem conclusion

  • Code has been corrected to consider both the English and
    translated versions of the RUN command.
    

Temporary fix

Comments

APAR Information

  • APAR number

    PI58178

  • Reported component name

    QMF-QUERY MGMT

  • Reported component ID

    566872101

  • Reported release

    B10

  • Status

    CLOSED PER

  • PE

    NoPE

  • HIPER

    NoHIPER

  • Special Attention

    NoSpecatt / Xsystem

  • Submitted date

    2016-02-26

  • Closed date

    2016-03-07

  • Last modified date

    2016-04-05

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

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

    UI35916

Modules/Macros

  • DSQHESQL DSQIESQL
    

Fix information

  • Fixed component name

    QMF-QUERY MGMT

  • Fixed component ID

    566872101

Applicable component levels

  • RB10 PSY UI35916

       UP16/03/08 P F603

Fix is available

  • Select the PTF appropriate for your component level. You will be required to sign in. Distribution on physical media is not available in all countries.

[{"Business Unit":{"code":"BU054","label":"Systems w\/TPS"},"Product":{"code":"SSCWRCK","label":"QMF for TSO\/CICS"},"Component":"","ARM Category":[],"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"11.1","Edition":"","Line of Business":{"code":"LOB35","label":"Mainframe SW"}}]

Document Information

Modified date:
05 April 2016