1 Reply Latest reply: Apr 16, 2012 11:00 AM by Gennady Sigalaev RSS

    How can I use User-Defined Aggregate Functions in Timesten 11? such as ODCI

    user6258915
      Hi
      we are using Timesten 11 version and as per the documentation, it doesn't support User-Defined Aggregate Functions.

      So we are looking for alternatives to do it. Could you please provide your expert voice on this.

      Thanks a lot.

      As the following:

      create or replace type strcat_type as object (
      cat_string varchar2(32767),
      static function ODCIAggregateInitialize(cs_ctx In Out strcat_type) return number,
      member function ODCIAggregateIterate(self In Out strcat_type,value in varchar2) return number,
      member function ODCIAggregateMerge(self In Out strcat_type,ctx2 In Out strcat_type) return number,
      member function ODCIAggregateTerminate(self In Out strcat_type,returnValue Out varchar2,flags in number) return

      number
      )



      How can I use User-Defined Aggregate Functions in Timesten 11? such as ODCIAggregateInitialize ?