Skip to main content

PM70169: USING LZ EDIT CODE ISSUING LAYOUT FORM COMMAND IN QMF RESULTS IN ERROR RUNNING DSQAEL0B, LINE 551: BAD ARITHMETIC CONVERSION


A fix is available

Subscribe

You can track all active APARs for this component.

 

APAR status

  • Closed as program error.

Error description

  • USING LZ EDIT CODE WHEN IMPORTED FORM IN QMF RESULTS IN ERROR
    551+++ RUNNING DSQAEL0B, LINE 551: BAD ARITHMETIC CONVERSION
    

Local fix

Problem summary

  • ****************************************************************
    * USERS AFFECTED: All QMF for TSO/CICS users of the QMF        *
    *                 LAYOUT FORM command.                         *
    ****************************************************************
    * PROBLEM DESCRIPTION: When the Z or C edit code is used on    *
    *                      numeric columns in a QMF form, the      *
    *                      error message:                          *
    *                                                              *
    *                      552 +++  wd.i = precision +  placecnt   *
    *                      IRX0041I Error running DSQAEL0B, line   *
    *                      552: Bad arithmetic conversion          *
    *                                                              *
    *                      is received when the LAYOUT FORM        *
    *                      command is issued.                      *
    ****************************************************************
    * RECOMMENDATION:                                              *
    ****************************************************************
    The REXX EXEC *.SDSQEXCE(DSQAEL0A) processes the *Z and *C edit
    codes (LZ, PZ, DCZ, etc.) as numeric values.  It tries to add
    the Z, C, or ZC to another numeric value and fails with
    "Bad arithmetic conversion".
    Code was written to anticipate only edit codes like L2.
    

Problem conclusion

  • Logic was amended in DSQAEL0B to avoid performing arithmetic
    operations on nonnumeric data.
    
    A blank will appear in the laid out form for any columns that
    have been assigned *Z or *C edit codes.
    

Temporary fix

Comments

APAR Information

  • APAR number

    PM70169

  • Reported component name

    QMF-QUERY MGMT

  • Reported component ID

    566872101

  • Reported release

    A10

  • Status

    CLOSED PER

  • PE

    NoPE

  • HIPER

    NoHIPER

  • Special Attention

    NoSpecatt

  • Submitted date

    2012-08-02

  • Closed date

    2012-08-20

  • Last modified date

    2012-09-05

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

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

    UK81202

Modules/Macros

  •    DSQAEL0B
    

Fix information

  • Fixed component name

    QMF-QUERY MGMT

  • Fixed component ID

    566872101

Applicable component levels

  • RA10 PSY UK81202

       UP12/08/22 P F208

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.

Rate this page:

(0 users)Average rating

Copyright and trademark information

IBM, the IBM logo and ibm.com are trademarks of International Business Machines Corp., registered in many jurisdictions worldwide. Other product and service names might be trademarks of IBM or other companies. A current list of IBM trademarks is available on the Web at "Copyright and trademark information" at www.ibm.com/legal/copytrade.shtml.

Rate this page:


(0 users)Average rating

Add comments

Document information

DB2 Query Management Facility

QMF for TSO/CICS


Software version:
10.1.0


Reference #:
PM70169


Modified date:
2012-09-05

Translate my page

Content navigation