BTS Developers Support...

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&context=SSP6X2&context=SSVHPS&context=SSHPYE&q1=bts&q2=basic+text+search&uid=swg1IC54959&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

Cesar Inacio Martins wrote: > 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&context=SSP6X2&context=SSVHPS&context=SSHPYE&q1=bts&q2=basic+text+search&uid=swg1IC54959&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 > <http://br.rd.yahoo.com/mail/taglines/mail/*http://br.new.mail.yahoo.com/addresses>; > com a sua cara @ymail.com ou @rocketmail.com. If it is the same problem as the APAR, you can try to use the workaround presented. The issue should be corrected in IDS 11.50 (BTS 1.10). Regards. -- Fernando Nunes Portugal http://informix-technology.blogspot.com My email works... but I don't check it frequently...