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