APAR status
Closed as program error.
Error description
Missing property : "Preserve Type" property in Aggregator stage is missing in DS 7.5.1.
Local fix
Problem summary
**************************************************************** USERS AFFECTED: Preserve Type sub-property not available in 7.5.1a. **************************************************************** PROBLEM DESCRIPTION: Currently all group operator aggregation requires the incoming data to be either a dfloat or a decimal. If the incoming field doesn't match either of these, then the field is forced to be one or the other. The customer would like to be able to reduce on other field types, specifically string, date, and timestamp. Since not all of the forms of aggregation apply to these data types, the customer only needs a subset of the operations (just min and max support). These comparisons should be done in the actual type specified. **************************************************************** RECOMMENDATION: patch for APAR JR34374 needs to be applied. ****************************************************************
Problem conclusion
Group operator was not originally designed to be able to handle anything other than number data types. Special Functionality needed to be added in order to accommodate the desired functionality. Fix Summary : A -preserveType flag has been added to the -reduce and -rereduce arguments to the group operator. When this is specified, the type of the value specified for the reducer input is used. -preserveType is mutually exclusive with every form of reduction except for the -min and -max arguments. Although the UI will have the added ability of being able to specify this flag, additional work will need to be done when the customer specifies this flag, since the UI still assumes the dfloat and decimal types are all that exist as output possibilities. A modify after the operator
Temporary fix
Comments
APAR Information
APAR number
JR34374
Reported component name
WIS DATASTAGE
Reported component ID
5724Q36DS
Reported release
751
Status
CLOSED PER
PE
NoPE
HIPER
NoHIPER
Special Attention
NoSpecatt
Submitted date
2009-09-24
Closed date
2009-10-19
Last modified date
2009-10-19
APAR is sysrouted FROM one or more of the following:
APAR is sysrouted TO one or more of the following:
Fix information
Fixed component name
WIS DATASTAGE
Fixed component ID
5724Q36DS
Applicable component levels
R751 PSN
UP
[{"Business Unit":{"code":"BU059","label":"IBM Software w\/o TPS"},"Product":{"code":"SSVSEF","label":"IBM InfoSphere DataStage"},"Component":"","ARM Category":[],"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"7.5.1","Edition":"","Line of Business":{"code":"LOB10","label":"Data and AI"}}]
Document Information
Modified date:
19 October 2009