cannot add index 212
I´have a problem during creating a functional index
create index idx_func_gera
on tbtransacao (gera_data(trn_data,trn_hora))
in datadbs01 ;
Informix erro :
212 - cannot add index
Someone could help ?
Carlos Rodrigo Marquez
Analista de Banco de Dados
www.orizonbrasil.com.br
Fone : 4932-5147
Cel : 8595-5145
What's the ISAM error code? I suspect that the function, gera_data, is not
marked as invariant. You'll have to recreate it invariant or ALTER it to
add that status to the function if it's not there. If that's not it, then
post the ISAM error.
Art
On Mon, Jan 19, 2009 at 11:11 AM, Carlos Rodrigo Marquez C e Silva <
crmcastro@orizonbrasil.com.br> wrote:
> I´have a problem during creating a functional index
>
> create index idx_func_gera>
> on tbtransacao (gera_data(trn_data,trn_hora))
>
> in datadbs01 ;
>
> Informix erro :
>
> 212 - cannot add index
>
> Someone could help ?
>
> Carlos Rodrigo Marquez
>
> Analista de Banco de Dados
>
> www.orizonbrasil.com.br
>
> Fone : 4932-5147
>
> Cel : 8595-5145
>
>
>
>
*******************************************************************************
> Forum Note: Use "Reply" to post a response in the discussion forum.
>
>
--
Art S. Kagel
Oninit (www.oninit.com)
IIUG Board of Directors (art@iiug.org)
Disclaimer: Please keep in mind that my own opinions are my own opinions and
do not reflect on my employer, Oninit, the IIUG, nor any other organization
with which I am associated either explicitly or implicitly. Neither do
those opinions reflect those of other individuals affiliated with any entity
with which I am affiliated nor those of the entities themselves.