RE: Problem with dostats

Posted in 2004

Bill Dare — Fri, 28 May 2004 08:09:54 -0400 — source: Usenet: comp.databases.informix

-461 is a strange error to get when fetching a cursor. You could try checking the items listed in "finderr 461". This is the SQL that is failing: sprintf( statement2, "SELECT colno, colname " " FROM syscolumns " " WHERE tabid = %d" " ORDER BY colno", tabinfo.tabid ); Try oncheck -cc and see if you get any errors. Regards, Bill > -----Original Message----- > From: Dale Gilbert [SMTP:dgilbert@nationalclearing.com] > Sent: Thursday, May 27, 2004 3:41 PM > To: informix-list@iiug.org > Subject: Problem with dostats > > I am getting the following error running dostats: > Cannot FETCH curs2. SQL=-461, ISAM=0 > > I have this same binary running on several other Sun servers (IDS > v7.31UD1) without problem. I get this error if I try to do the entire > instance, a single db or single table. > > Thanks > > sending to informix-list sending to informix-list