Re: Strange error code

Art Kagel wrote: > I'm getting an undefined error code from a dbcopy run: -1831. Finderr > says it's an unknown error code. > > Can anyone at IBM look that one up for me? > > Art Cannot update statistics for subtable -- Ciao, Marco ______________________________________________________________________________ Marco Greco /UK /IBM Standard disclaimers apply! Structured Query Scripting Language http://www.4glworks.com/sqsl.htm 4glworks http://www.4glworks.com Informix on Linux http://www.4glworks.com/ifmxlinux.htm

Marco Greco wrote: > > Art Kagel wrote: >> I'm getting an undefined error code from a dbcopy run: -1831. Finderr >> says it's an unknown error code. >> >> Can anyone at IBM look that one up for me? >> >> Art > > Cannot update statistics for subtable > ....seems an odd error to get....are you playing with table hierarchies? SQL1831N Table statistics for a subtable "<subtable-name>" cannot be updated. Explanation: The statement attempts to update the statistics values of NPAGES, FPAGES, or OVERFLOW, for table "<subtable-name>", that is defined as a subtable. For typed tables, these statistics can only be updated using the root table of the table hierarchy. The statement cannot be processed. User response: Update the catalog statistics for the root table of the table hierarchy instead of the subtable. sqlcode: -1831 sqlstate: 428DY -- Serge Rielau SQL Architect DB2 for LUW IBM Toronto Lab

This is the Informix mailing list or news group ... On Tue, Sep 1, 2009 at 19:05, Serge Rielau<srielau@ca.ibm.com> wrote: > Marco Greco wrote: >> >> Art Kagel wrote: >>> I'm getting an undefined error code from a dbcopy run: -1831.  Finderr >>> says it's an unknown error code. >>> >>> Can anyone at IBM look that one up for me? >>> >>> Art >> >> Cannot update statistics for subtable >> > ....seems an odd error to get....are you playing with table hierarchies? > > SQL1831N  Table statistics for a subtable "<subtable-name>" cannot be >       updated. > > Explanation: > > The statement attempts to update the statistics values of NPAGES, > FPAGES, or OVERFLOW, for table "<subtable-name>", that is defined as a > subtable. For typed tables, these statistics can only be updated using > the root table of the table hierarchy. > > The statement cannot be processed. > > User response: > > Update the catalog statistics for the root table of the table hierarchy > instead of the subtable. > >  sqlcode: -1831 > >  sqlstate: 428DY >From an 11.50.FC4 installation of IDS: Osiris JL: chkmsg -1831 -1831: Combination of FetArrSize Deferred-PREPARE and OPTOFC is not supported. Osiris JL: I think the message needs fixing to read (something like): -1831: The combination of explicit fetch array size, deferred PREPAREand OPTOFC is not supported. -- Jonathan Leffler #include <disclaimer.h> Email: jleffler@earthlink.net, jleffler@us.ibm.com Guardian of DBD::Informix v2008.0513 -- http://dbi.perl.org/ "Blessed are we who can laugh at ourselves, for we shall never cease to be amused." NB: Please do not use this email for correspondence. I don't necessarily read it every week, even. Stephen Leacock - "I detest life-insurance agents: they always argue that I shall some day die, which is not so." - http://www.brainyquote.com/quotes/authors/s/stephen_leacock.html