A fix is available
APAR status
Closed as new function.
Error description
HPU will handle casting decimal data to date or time based on date or time format options specified. The conversions required are generally very straight forward. The Decimal columns can be assumed to match directly onto the date/time formats. i.e. - if the target date format is YYYYMMDD then the decimal is (8,0) with each digit maping onto that format. - If it's YYMMDD, or time HHMMSS then it's Decimal (6,0) etc. For example: Decimal Date value is 19841201 becomes Date '1984-12-01' And decimal Time value 121001 becomes '12:10:01' In both cases the output format should be controlled by the HPU Date and Time options. Format DATE_C matches what is required in our example, and TIME_A with TIMEDELIM ':' will give the required Time format. OTHER KEYWORDS: RFE 82839 RFE82839 PB44176
Local fix
Problem summary
**************************************************************** * USERS AFFECTED: Users of IBM DB2 High Performance Unload * * z/OS. * **************************************************************** * PROBLEM DESCRIPTION: HPU doesn't allow decimal data to be * * cast as time or date when unloading * * from an image copy. * * * * HPU should handle casting decimal data * * to date or time based on date or * * time format options specified. * * pb 44176 * **************************************************************** * RECOMMENDATION: APPLY the PTF. * **************************************************************** N/A (enhancement)
Problem conclusion
Temporary fix
Comments
APPLY the PTF.
APAR Information
APAR number
PI74203
Reported component name
DB2 HI PERF UNL
Reported component ID
5697F4400
Reported release
430
Status
CLOSED UR1
PE
NoPE
HIPER
NoHIPER
Special Attention
NoSpecatt / Xsystem
Submitted date
2016-12-27
Closed date
2017-01-10
Last modified date
2017-02-01
APAR is sysrouted FROM one or more of the following:
APAR is sysrouted TO one or more of the following:
Modules/Macros
INZTPMEM
Fix information
Fixed component name
DB2 HI PERF UNL
Fixed component ID
5697F4400
Applicable component levels
R430 PSY UI43799
UP17/01/16 P F701
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":"BU059","label":"IBM Software w\/o TPS"},"Product":{"code":"SSAUUV","label":"IBM Db2 High Performance Unload for z\/OS"},"Component":"","ARM Category":[],"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"4.3.0","Edition":"","Line of Business":{"code":"LOB10","label":"Data and AI"}}]
Document Information
Modified date:
12 February 2021