IBM Support What's New?

PM68835: FM IS NOT CORRECTLY PROCESSING THE SQLDA RETURNED BY DB2

A fix is available

Subscribe

You can track all active APARs for this component.

APAR status

  • Closed as program error.

Error description

  • When using FM/DB2 option 4 SQL, then 1 basic, when we enter the
    name of a table, the column NAME is not filled.
    

Local fix

  • n/a
    

Problem summary

  • ****************************************************************
    * USERS AFFECTED: 1. All users of File Manager DB2 component,  *
    *                 specifically customers using CCSID 1147      *
    *                 (French EBCDIC).                             *
    *                 2. All users of File Manager DB2 component.  *
    ****************************************************************
    * PROBLEM DESCRIPTION: 1. The File Manager DB2 component Basic *
    *                      SQL prototyper shows blank column       *
    *                      values.                                 *
    *                      2. The documented default value for the *
    *                      editor 'Commit after data fetch' option *
    *                      is incorrect.                           *
    ****************************************************************
    * RECOMMENDATION: Apply the provided PTF.                      *
    ****************************************************************
    1. The SQLDA entry for the constant '#1 ' (3 characters) is 4
    bytes in length when using CCSID 1147.
    2. The default for the editor 'Commit after data fetch' option
    is selected (the documentation states the default is not
    selected).
    

Problem conclusion

  • 1. File Manager DB2 component has been updated to correct the
    problem.  Note that this APAR introduces a change in behaviour
    to the 'Basic SELECT Prototyping' function.  The change is to
    replace the use of the '#' in any table correlation references
    (eg #1, #2 etc) displayed by the function.  A capital letter is
    now used, eg T1, T2 etc.  See the documentation changes
    associated with this APAR for more information.
    2. The File Manager DB2 component documentation has been changed
    to reflect the correct default value for the editor 'Commit
    after data fetch' option (APAR PM76622)
    
    Publication Closing Code: DEVCHNG
    For the documentation changes associated with this APAR,
    please refer to:
    ftp://public.dhe.ibm.com/software/websphere/awdtools/
        filemanager/fmv12apar.pdf
    
    The changes are to the following publications:
    
    PUB ID        PUB NAME
    ------------  ----------------------------------------
    
    SC19-3675-00  File Manager for z/OS V12R1 User's Guide
                  and Reference for DB2 Data
    
    The latest published manuals can be found at:
    http://www.ibm.com/software/awdtools/filemanager/library/
           index.html.
    

Temporary fix

Comments

APAR Information

  • APAR number

    PM68835

  • Reported component name

    FILE MANAGER Z/

  • Reported component ID

    5655W6800

  • Reported release

    C12

  • Status

    CLOSED PER

  • PE

    NoPE

  • HIPER

    NoHIPER

  • Special Attention

    NoSpecatt

  • Submitted date

    2012-07-13

  • Closed date

    2012-11-19

  • Last modified date

    2012-12-04

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

    PM64698

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

    UK83654 UK83655 UK83656 UK83657 UK83658

Modules/Macros

  • FMNASMX  FMNAUDCH FMNAUDDS FMNAUD2  FMNCAS2
    FMNCBIN  FMNCBLX  FMNCPCK  FMNDA10  FMNDB05  FMNDB06  FMNDB0
    
    ***This field was truncated.  To obtain the full apar record, please contact your local support center.***
    

Publications Referenced
SC19367500        

Fix information

  • Fixed component name

    FILE MANAGER Z/

  • Fixed component ID

    5655W6800

Applicable component levels

  • RC1B PSY UK83655

       UP12/11/24 P F211

  • RC10 PSY UK83654

       UP12/11/24 P F211

  • RC12 PSY UK83656

       UP12/11/24 P F211

  • RC13 PSY UK83657

       UP12/11/24 P F211

  • RC14 PSY UK83658

       UP12/11/24 P F211

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.



Document information

More support for: File Manager for z/OS

Software version: C12

Reference #: PM68835

Modified date: 2012-12-04