Re: Cannot read system catalog (systables)

For my own good luck it allowed me to remove that view after a few hours. Why would that happen ? Is anything like COMMIT that I should enter after I create a view ? The SQL that was included on that view would take a couple of hours to display all of the resultset. Maybe something was running inside ? I am afraid now to create other views as the same thing might happen ? I am very new to Informix, how can I see the log file (we have RedHat ES 3.0) Thanks for all the help. Genti On 5/18/06, Davorin Kremenjas <davorin.kremenjas@alfatec.hr> wrote: > Try "oncheck -cc" first. > > "Gentian Hila" <genti.tech@gmail.com> wrote in message > news:mailman.71.1147884695.19084.informix-list@iiug.org... > We have IDS 9.40. > > I created a view called SalesReport for a report that we are creating. > It worked ok. After a while we found out that the view needed to be > modified. > Dropped the view and recreated it. > > Not I cannot query anymore that queue or delete or replace it. > > When I try to drop it or read from it, I get the following: > > Cannot read system catalog (systables). > > If I try to create the view again I get: > > Cannot update system catalog (systables) > > But I can read, write, to any table or view, and can create other > views just fine. > > Also the crystal report when connected to the database shows no Tables > or Views at all anymore. However, I am able from the same report to > see other db that are on the same server. > > Please help what to do. > > Thanks a lot. > > Genti > > > _______________________________________________ > Informix-list mailing list > Informix-list@iiug.org > http://www.iiug.org/mailman/listinfo/informix-list >