768: Internal error in routine opjoin().

Posted in 2006

Henry — 5 Oct 2006 23:05:53 -0700 — source: Usenet: comp.databases.informix

Hi all, I hit with an error while executing a sql query. The error message is: 768: Internal error in routine opjoin(). Any idea what is it and how to solve it? Thanks for your help!

↪ replying to Henry

Superboer — 6 Oct 2006 04:32:15 -0700 — source: Usenet: comp.databases.informix

Phone TS. sounds like you hit a bug. run oncheck for the affected tables....execute qry. if error then try update stats for the tables-->> execute qry. if error then try update stats drop distributions for the tables affected -->>execute qry. if error then update stats medium or high;-->> better use Arts dostats for it ... -->>execute qry. if still error ... sorry. DO CONTACT TS Superboer. Henry schreef: > Hi all, > > I hit with an error while executing a sql query. The error message is: > > 768: Internal error in routine opjoin().> > Any idea what is it and how to solve it? > > Thanks for your help!

↪ replying to Superboer

scottishpoet — 6 Oct 2006 07:15:30 -0700 — source: Usenet: comp.databases.informix

Known defects exist that report this error, in particular with left outer ansi joins Fixes should be available Contact your support provider