IC72022: A SELECT DISTINCT STATEMENT ON A RESULT COLUMN OF DATETIME EXPRESSION RETURNS ERROR 1268

APAR status

• Closed as program error.

Error description

• Running a select distinct statement on a result column from the
  summation of a datetime expression returns error -1268.
  Datatype change to decimal or integer does not reproduce the
  problem.
  
  Example:
  create table tab1 (col1 datetime year to second, col2 datetime
  year to second);
  insert into tab1 values( current, current);
  insert into tab1 values( current, current);
  select col2-col1 out1 from tab1 into temp tab2 with no log;
  select sum(out1) out2 from tab2 into temp tab3 with no log;
  select distinct out2 from tab3;
  

Local fix

Problem summary

• ****************************************************************
  * USERS AFFECTED:                                              *
  * All Users                                                    *
  ****************************************************************
  * PROBLEM DESCRIPTION:                                         *
  * Aggregation operations (SUM, AVG) involving datetime and     *
  * interval expressions returns error -1268                     *
  ****************************************************************
  * RECOMMENDATION:                                              *
  * Upgrade to IDS 11.50.xC7W3 or higher versions                *
  ****************************************************************
  

Problem conclusion

• The problem is fixed in IDS 11.50.xC7W3 and higher versions
  

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

  IBM IDS ENTRP E

• Fixed component ID

  5724L2304

Applicable component levels

• RB15 PSY

     UP