A fix is available
APAR status
Closed as program error.
Error description
When viewing a DB2 table using File Manager DB2 option 1, receive the following message - DSNT408I SQLCODE = -332, ERROR: CHARACTER CONVERSION BETWEEN CCSID 1200 to 65534 REQUESTED BY DSNXROHB IS NOT SUPPORTED Additional Information: SQLCODE-332 in the FM/DB2 editor processing a unicode-encoded table created prior to DB2 version 8 with graphic columns, on a DB2 system with MIXED=NO in the DB2 DSNHDECM module.
Local fix
N/A
Problem summary
**************************************************************** * USERS AFFECTED: All users of File Manager DB2 component. * **************************************************************** * PROBLEM DESCRIPTION: 1. SQLCODE-332 in the FM/DB2 editor of * * a table with GRAPHIC columns in a * * unicode-encoded table, host DB2 system * * has DSNHDECM parameter MIXED=NO. * * 2. SQLCODE-332 entering a free-form * * SELECT statement with GRAPHIC columns * * in a unicode-encoded table, host DB2 * * system has DSNHDECM parameter * * MIXED=NO. * **************************************************************** * RECOMMENDATION: Apply the provided PTF. * **************************************************************** The problem occurs only when the affected table was created prior to DB2 version 8. Column SYSIBM.SYSCOLUMNS.CCSID for the GRAPHIC datatype columns has value 0. The problem can occur processing an affected table directly using the FM/DB2 editor, or by entering a SELECT statement that accesses the affected table using FM/DB2 options 4.1-4.4.
Problem conclusion
File Manager DB2 component has been updated to correct the problem.
Temporary fix
Comments
APAR Information
APAR number
PI38197
Reported component name
FILE MANAGER Z/
Reported component ID
5655W6800
Reported release
C12
Status
CLOSED PER
PE
NoPE
HIPER
NoHIPER
Special Attention
NoSpecatt / Xsystem
Submitted date
2015-03-31
Closed date
2015-05-29
Last modified date
2015-07-01
APAR is sysrouted FROM one or more of the following:
APAR is sysrouted TO one or more of the following:
Modules/Macros
FMN0LVL FMN2LVL
Fix information
Fixed component name
FILE MANAGER Z/
Fixed component ID
5655W6800
Applicable component levels
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":"C12","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":"C12","Edition":"","Line of Business":{"code":"LOB35","label":"Mainframe SW"}}]
Document Information
Modified date:
01 July 2015