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  FMNDB07
    FMNDB11  FMNDB48  FMNDB80  FMNDB82  FMNDB85  FMNDB88  FMNDB89
    FMNDC19  FMNDD03  FMNDD04  FMNDD60  FMNDSP   FMNDYNTP FMNEDIPP
    FMNEDIT  FMNEDIT1 FMNEDIT2 FMNEDIT3 FMNEDIT4 FMNEDIT6 FMNED0DY
    FMNED0SE FMNED008 FMNED1EX FMNED4CE FMNED4CR FMNED4D  FMNED4EX
    FMNED4F  FMNED4IN FMNED4LB FMNED4TM FMNED4XL FMNEGXML FMNESRTM
    FMNFILTR FMNISPF  FMNKYPOS FMNLKTAB FMNLOCAL FMNLOG2  FMNMAIN
    FMNOPTP2 FMNPLIX  FMNPPCLA FMNPPMN  FMNPPNAV FMNPPTOK FMNRDCCO
    FMNRDFFD FMNRDFNM FMNRDFSG FMNRDFTB FMNRDMSC FMNRDR   FMNRDRAR
    FMNRDRCV FMNRDR2  FMNRDUFD FMNRDUHX FMNRDUSG FMNRDUTB FMNRDUZD
    FMNRDU2V FMNRDXML FMNRD2IN FMNRMBAE FMNRMCHK FMNRMDAT FMNRMINI
    FMNRMPOP FMNRMR   FMNRMRED FMNRMR2  FMNRMUPD FMNSCREX FMNSCRFD
    FMNSPAW3 FMNSQLTF FMNTMPXU FMNTPBFM FMNTPDFD FMNTPEFL FMNTPEFM
    FMNTPEVL FMNTRTMP FMNTSO   FMNUNICV FMN0LVL  FMN0SAF  FMN1LVL
    FMN1RMDT FMN2$CPJ FMN2$CPK FMN2$CPR FMN2ABUF FMN2ABXT FMN2ACNM
    FMN2AJSQ FMN2ASQD FMN2ATXT FMN2AUDI FMN2A2IO FMN2BCNL FMN2BCTQ
    FMN2BDBQ FMN2BNCL FMN2BN0K FMN2BN9K FMN2BONM FMN2BUCL FMN2BUTQ
    FMN2CATQ FMN2CD2V FMN2CF2B FMN2CGM2 FMN2CHKI FMN2CKCN FMN2CNVR
    FMN2CPYB FMN2CSQI FMN2CTMP FMN2CTM1 FMN2CTM2 FMN2CTQ2 FMN2C2IO
    FMN2DATA FMN2DBC  FMN2DBI  FMN2DBJ  FMN2DBO  FMN2DBOL FMN2DBP
    FMN2DBV  FMN2DBX  FMN2DBY  FMN2DCIO FMN2DCMD FMN2DCRE FMN2DENP
    FMN2DENU FMN2DIUS FMN2DJPN FMN2DKOR FMN2D2C  FMN2D2E  FMN2D2EC
    FMN2D2EE FMN2D2EG FMN2D2EI FMN2D2EL FMN2D2ES FMN2D2G  FMN2D2IO
    FMN2D2I8 FMN2D2SP FMN2EDSP FMN2EDT1 FMN2EOBN FMN2ERR  FMN2ETRC
    FMN2EXSY FMN2FDCN FMN2FE43 FMN2FMT  FMN2FSQC FMN2FTJV FMN2FTPC
    FMN2FXNM FMN2GISQ FMN2GSC0 FMN2GSC9 FMN2GVW0 FMN2GVW9 FMN2GV20
    FMN2GV29 FMN2HLI  FMN2IDTB FMN2INTE FMN2INTJ FMN2INTP FMN2INTS
    FMN2IPSU FMN2ISPF FMN2ISQ  FMN2ISQG FMN2ISQI FMN2ISQS FMN2ITSV
    FMN2IVSU FMN2LIBS FMN2LOCL FMN2LVL  FMN2LVLJ FMN2LVLK FMN2MAIN
    FMN2MENU FMN2MISC FMN2MJPN FMN2MKOR FMN2MXXX FMN2NFMC FMN2OPTL
    FMN2PDP  FMN2PFMS FMN2POCX FMN2POL  FMN2POLJ FMN2POLK FMN2POLL
    FMN2POLM FMN2POLP FMN2POLT FMN2POLX FMN2POPT FMN2POXK FMN2PRDT
    FMN2PRVP FMN2PSBT FMN2PSE0 FMN2PSX2 FMN2PTXC FMN2PXO1 FMN2RALI
    FMN2RMDT FMN2RMQ  FMN2RMR  FMN2RMR2 FMN2RMUT FMN2ROCX FMN2ROXC
    FMN2ROXK FMN2RO3H FMN2RTXC FMN2RXO8 FMN2R41U FMN2R41V FMN2SADA
    FMN2SAGF FMN2SAPR FMN2SBPR FMN2SCON FMN2SCRE FMN2SCST FMN2SEDX
    FMN2SELS FMN2SENX FMN2SERR FMN2SHSQ FMN2SIDM FMN2SNTX FMN2SNXP
    FMN2SQLC FMN2SQSU FMN2SQS2 FMN2SQTB FMN2SSDM FMN2SSID FMN2SSQL
    FMN2SSSU FMN2STG  FMN2STRP FMN2STSS FMN2STS2 FMN2STS3 FMN2STUT
    FMN2SXPM FMN2SXPX FMN2TBL  FMN2TCRE FMN2TTBL FMN2UBLD FMN2XSQL
    FMN2ZCRE JADLC12J
    

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.



Rate this page:

(0 users)Average rating

Add comments

Document information


More support for:

z/OS family

Software version:

C12

Reference #:

PM68835

Modified date:

2012-12-04

Translate my page

Machine Translation

Content navigation