IBM Support

PM40296: AFTER APPLYING PTF UK59244, FM/DB2 EXPORT UTILITY (DBX) OUTPUT DATA CONTAINS ADDITIONAL DOUBLE QUOTES.

A fix is available

Subscribe

You can track all active APARs for this component.

 

APAR status

  • Closed as program error.

Error description

  • After applying PTF UK59244, when running FM/DB2 Export utiltity
    (DBX), output data contains additional double quotes around all
    of the data in a column.
    

Local fix

Problem summary

  • ****************************************************************
    * USERS AFFECTED: All users of File Manager DB2 component,     *
    *                 export function, CSV format.                 *
    ****************************************************************
    * PROBLEM DESCRIPTION: After applying UK59244, the output from *
    *                      FM/DB2 export, in CSV format, may       *
    *                      contain additional double quotes.       *
    ****************************************************************
    * RECOMMENDATION: Apply the provided PTF.                      *
    ****************************************************************
    PTF UK59244 introduced several enhancements for the FM/DB2
    export function, CSV data format.  In the situation where the
    data in a character column is already encapsulated in a user-
    defined character, FM/DB2 may add additional enclosing double
    quotes.  An example is $Fredo, from$ - where $ is a user defined
    encapsulation character included because of the imbedded comma -
    the default CSV separation character.  In this situation the
    addition of enclosing double quotes is unnecessary.
    

Problem conclusion

  • This APAR provides an enhancement to FM/DB2 export, CSV data
    format, allowing an "ASIS" encapsulation option.  When this
    option is selected, character data is exported "ASIS", even when
    the data contains, for example, an imbedded separator character,
    or double quote.
    
     Publication Closing Code: DEVCHNG
    For the documentation changes associated with this APAR,
    please refer to:
    ftp://ftp.software.ibm.com/software/websphere/awdtools/
        filemanager/fmv10apar.pdf
    
    The changes are to the following publications:
    
    PUB ID        PUB NAME
    ------------  ----------------------------------------
    
    SC19-2858-00  File Manager for z/OS V10R1 Users's Guide
                  and Reference for DB2 data
    

Temporary fix

Comments

APAR Information

  • APAR number

    PM40296

  • Reported component name

    FILE MANAGER ZO

  • Reported component ID

    5655V5200

  • Reported release

    A12

  • Status

    CLOSED PER

  • PE

    NoPE

  • HIPER

    NoHIPER

  • Special Attention

    YesSpecatt / New Function / Xsystem

  • Submitted date

    2011-05-27

  • Closed date

    2011-08-18

  • Last modified date

    2011-09-07

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

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

    UK70930 UK70931 UK70932 UK70933 UK70934 PM47273

Modules/Macros

  • FMNASMX  FMNCBIN  FMNCBLX  FMNCM2FO FMNCOMN1
    FMNCONS1 FMNCPCK  FMNDB85  FMNEDIT  FMNEDIT6 FMNED0DY FMNED1EX
    FMNPLIX  FMNRDFFD FMNRDFNM FMNRDFSG FMNRDFTB FMNRDR2  FMNRDUFD
    FMNRDU2V FMN0LVL  FMN1DBIB FMN1DIFF FMN1FIL1 FMN1ICOF FMN1ICPY
    FMN1LPST FMN1LVL  FMN1NOXP FMN1PORG FMN1RMDT FMN1TERM FMN1VLDO
    FMN2AUDI FMN2CGM2 FMN2CTM1 FMN2DBC  FMN2DBI  FMN2DBP  FMN2DBX
    FMN2DBY  FMN2D2E  FMN2D2EC FMN2D2EG FMN2D2EI FMN2D2EL FMN2EDT1
    FMN2FDBX FMN2FXAI FMN2FX26 FMN2IDTB FMN2ISQG FMN2ISQI FMN2LOCL
    FMN2LVL  FMN2LVLJ FMN2LVLK FMN2MENU FMN2MJPN FMN2MKOR FMN2MXXX
    FMN2PEXI FMN2PXOB FMN2PXO1 FMN2PXO2 FMN2RBKW FMN2REXL FMN2RMDT
    FMN2RMR  FMN2RMR2 FMN2RMUT FMN2RXO7 FMN2SBPR FMN2SEDX FMN2SELS
    FMN2SENX
    

Publications Referenced
SC19285800    

Fix information

  • Fixed component name

    FILE MANAGER ZO

  • Fixed component ID

    5655V5200

Applicable component levels

  • RA1B PSY UK70931

       UP11/08/24 P F108

  • RA10 PSY UK70930

       UP11/08/24 P F108

  • RA12 PSY UK70932

       UP11/08/24 P F108

  • RA13 PSY UK70933

       UP11/08/24 P F108

  • RA14 PSY UK70934

       UP11/08/24 P F108

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":"SG19M","label":"APARs - z\/OS environment"},"Component":"","ARM Category":[],"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"A12","Edition":"","Line of Business":{"code":"","label":""}},{"Business Unit":{"code":"BU058","label":"IBM Infrastructure w\/TPS"},"Product":{"code":"SSXJAV","label":"File Manager for z\/OS"},"Component":"","ARM Category":[],"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"A12","Edition":"","Line of Business":{"code":"LOB35","label":"Mainframe SW"}}]

Document Information

Modified date:
07 September 2011