A fix is available
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
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