Hi,

   I using the BTS 1.10 with IDS 11.50 UC1 Developer.

   I have a situation here thats appear like a Bug.

   I found this APAR what look like my situation:  http://www-1.ibm.com/support/docview.wss?rs=630&context=SSGU8G&context=SSZ2HS&co
ntext=SSP6X2&context=SSVHPS&context=SSHPYE&q1=bts&q2=basic+text+search&uid=swg1I
C54959&loc=en_US&cs=utf-8&lang=en

   How works the support to BTS? Basead on this APAR I think will need the Informix Support or have any official group of developers what we can contact?
   

Information about my situation:
When execute a bts_contains with OR (SQL statement) a error occur:

   select count(*)
   from t_pergunta p, t_tag_perg t , outer t_resposta_cl r, t_tags tg
   where p.cod_pergunta = t.cod_pergunta
   and r.cod_pergunta = p.cod_pergunta
   and tg.cod_tag = t.cod_tag
   OR  bts_contains(r.resposta , "DML") ;
   
   (BTS22) - bts error - bts_contains requires an index on the search column

When change the OR to AND , works fine:

   select count(*)
   from t_pergunta p, t_tag_perg t , outer t_resposta_cl r, t_tags tg
   where p.cod_pergunta = t.cod_pergunta
   and r.cod_pergunta = p.cod_pergunta
   and tg.cod_tag = t.cod_tag
   AND bts_contains(r.resposta , "DML") ;

     (count(*))

            250

     Novos endereços, o Yahoo! que você conhece. Crie um email novo com a sua cara @ymail.com ou @rocketmail.com.
http://br.new.mail.yahoo.com/addresses