APAR status
Closed as fixed if next.
Error description
I tested drill down for DateTime YEAR TO SECOND with the changes we had made, but it does not work. Generated drill down query for DateTime YEAR to SECOND value ? ?2009-08-03 13:02:05': SELECT * FROM informix."aaaa12" WHERE ("h" = '2009-08-04 09:09:05.000000' ) Expected Query: SELECT * FROM informix."aaaa12" WHERE ("h" = '2009-08-04 09:09:05? ) IA 8.1 RU3 on Windows Server 2003 with SQL Server 2005 repository. Informix version 10 Wire Protocol ODBC, VMIFCL23 Version 05.30.0096
Local fix
Problem summary
**************************************************************** USERS AFFECTED: Users using Drill Down against Informix datetime columns with the format as "Year to second" **************************************************************** PROBLEM DESCRIPTION: Drill Down of an Informaix Datetime column with "Year to second" format fails. **************************************************************** RECOMMENDATION: Upgrade to Information Analyzer 8.1 Rollup patch 5 or Information Analyzer 8.1.1 Rollup Patch 1. This change is also included in 8.1 Fix Pack 1. ****************************************************************
Problem conclusion
Job status will be correctly displayed.
Temporary fix
Comments
APAR Information
APAR number
JR34089
Reported component name
WIS INFORM ANAL
Reported component ID
5724Q36IA
Reported release
810
Status
CLOSED FIN
PE
NoPE
HIPER
NoHIPER
Special Attention
NoSpecatt
Submitted date
2009-08-25
Closed date
2009-10-09
Last modified date
2009-12-18
APAR is sysrouted FROM one or more of the following:
APAR is sysrouted TO one or more of the following:
Fix information
Applicable component levels
R810 PSN
UP
[{"Business Unit":{"code":"BU053","label":"Cloud & Data Platform"},"Product":{"code":"SSZJLG","label":"InfoSphere Information Analyzer"},"Component":"","ARM Category":[],"Platform":[{"code":"PF025","label":"Platform Independent"}],"Version":"8.1","Edition":"","Line of Business":{"code":"","label":""}}]
Document Information
Modified date:
18 December 2009