IBM IDS ENTRP E / 5724L2304 / B15 - IDS 11.50

Running a simple select with a sub select returns a -768 
internal error in routine aj_attjl 
 
select tap.as_of_datetime, tap.nike_fund_id, tap.preadd_qty 
, exists ( 
   select 1 from refr_share rs 
   join security_hist sh2 
     on sh2.nike_secrty_id = rs.nike_secrty_id 
     and sh2.history_nbr = 0 
     and sh2.secrty_class = 'DEBT' 
   where rs.nike_fund_id = tap.nike_fund_id //does not work 
  // where rs.nike_fund_id = tc.nike_fund_id   //works 
   and rs.as_of_date = 
      (select max(rs2.as_of_date) 
       from refr_share rs2 
       where rs2.nike_fund_id = rs.nike_fund_id 
       and rs2.nike_secrty_id = rs.nike_secrty_id 
       and rs2.as_of_date <= date(tap.as_of_datetime)) //does 
not work 
       //and rs2.as_of_date <= date(tc.as_of_datetime))  //works 
   and rs.qty is not null 
  ) has_treasury 
from trust_add_position tap 
join trust_cash tc 
 on tc.nike_fund_id = tap.nike_fund_id 
 and tc.as_of_datetime = tap.as_of_datetime 
where tap.as_of_datetime = '2009-04-21 16:00:00.000' 
and tap.nike_fund_id = 5986

**************************************************************** 
* USERS AFFECTED:                                              * 
* All users running a query which involves ansi-join with a    * 
* subquery with filters that can be promoted.                  * 
**************************************************************** 
* PROBLEM DESCRIPTION:                                         * 
* A query which involves an ansi-join with a filter that uses  * 
* a subquery with a filter which can be promoted might return  * 
* -768 error.                                                  * 
**************************************************************** 
* RECOMMENDATION:                                              * 
* Upgrade to IDS 11.50.xC5 or above                            * 
****************************************************************

Problem first fixed in IDS 11.50.xC5.

not known / see Local fix

Date  - problem reported    :
Date  - problem closed      :
Date  - last modified       :

06.05.2009
19.01.2010
19.01.2010

11.50.xC5