PI89993: AGE() FUNCTION AGAINST NETEZZA DB USING CQM TRUNCATES VALUE

APAR status

• Closed as Permanent restriction.

Error description

• Using AGE() function against Netezza DB using CQM does not
  return the full value. It truncates the year and month values.
  

Local fix

• use DQM
  

Problem summary

• n/a
  

Problem conclusion

• The Cognos Age function does not have the same semantics (value
  and data type)  as the Age function that Netezza has.
  
  The Cognos Age function is not pushed down to Netezza, it is
  computed locally.
  
  Cognos implementation
  _age ( date_expression )
  Returns a number that is obtained from subtracting
  "date_expression" from today's date. The returned value has the
  form YYYYMMDD, where YYYY represents the number of years, MM
  represents the number of months, and DD represents the number of
  days.
  Example: _age ( 1990-04-30 ) (if today's date is 2003-02-05)
  Result: 120906, meaning 12 years, 9 months, and 6 days.
  
  Netezza implementation
  
  Returns the interval between two timestamps. The returned value
  is of the same precision as the most precise argument. For
  example:
  ? select age('10-22-2003', '7-6-2002') returns '1 year 3 mons 16
  days'
  ? select age('10-22-2003 09:46:07.325', '7-6-2002') returns '1
  year 3 mons 16 days 09:46:07.325'
  If you specify a single argument, the function returns the
  interval between the current time and the specified timestamp.
  This is equivalent to age(CURRENT_TIMESTAMP, ts).
  

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

• Fixed component name

  COGNOS ANALYTIC

• Fixed component ID

  5724W12XX

Applicable component levels