Re: create index online

Posted in 2009

Davorin Kremenjas — Thu, 5 Nov 2009 04:08:46 -0800 (PST) — source: Usenet: comp.databases.informix

On Nov 5, 8:24 am, "Habichtsberg, Reinhard" <RHabichtsb...@arz- emmendingen.de> wrote: > Hi all, > > I created a new index ONLINE. Thought that would cause no problems in > production. > > However, one program reported errors: > > > Program stopped at "/home/projekte/p3_neu/lib/f_vo_upd.4gl", line number > > 464. > > Date: 04.11.2009 Time: 18:51:54 > > > Program error at "/home/projekte/p3_neu/lib/f_vo_upd.4gl", line number > > 464. > > SQL statement error number -710. > > > Table (informix.ap_da_v1) has been dropped, altered or renamed. Hi, what's your onconfig param AUTO_REPREPARE set to? If you reconnect your app this should go away, rebuilding an index on the table changed the table metadata (i.e. version). HTH Davorin

Related threads

informix error question
Reusing same Cursor name help (errors 710 and 4371)