JR34089: DRILL DOWN ON INFORMIX DATA SOURCE ERROR WITH DATETIME YEAR TO SECOND FORMAT.

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 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