set constraints failed

Hi, in dbaccess I execute the following query: set constraints for nom_table filtering without error; dbaccess return "Mod set" Then, I verify data in the sysobjstate table with the following query: select o.* from systables t, sysobjstate o where t.tabid = o.tabid and t.tabname = "nom_table"; This query return one row: objtype I owner informix name ix_inrcode tabid 253 state E Normally I should have a row in the sysobjstate with the state "F" (for "filtering"). I'm "DBA" in the database in which I execute the previous queries and I'm the owner of the table. Have you any ideas ? Thanks

Can you post the full table schema? Regards. On Tue, Nov 25, 2008 at 6:03 PM, OLIVIER CONSULTIX < olivier.calmettes@consult-ix.fr> wrote: > Hi, > > in dbaccess I execute the following query: > set constraints for nom_table filtering without error; > > dbaccess return "Mod set" > > Then, I verify data in the sysobjstate table with the following query: > select o.* > from systables t, sysobjstate o > where t.tabid = o.tabid > and t.tabname = "nom_table"; > > This query return one row: > objtype I > owner informix > name ix_inrcode > tabid 253 > state E > > Normally I should have a row in the sysobjstate with the state "F" (for > "filtering"). > > I'm "DBA" in the database in which I execute the previous queries and I'm > the > owner of the table. > > Have you any ideas ? > > Thanks > > > > ******************************************************************************* > Forum Note: Use "Reply" to post a response in the discussion forum. > > -- Fernando Nunes Portugal http://informix-technology.blogspot.com My email works... but I don't check it frequently...