dbschema errors

The following command: Dbschema -d mis_db -t all -ss > mis_db.sch Gives the following error message: -284 - A subquery has returned not exactly one row It errors at the point that I would expect the indexes to be scripted. I have dropped the table and indexes in question and it doesn't seem to help. The sysindexes table doesn't seem to have multiple index rows for this table. What could be the problem and how do I fix it? When I dropped this table, I ran a schema that was successful so I do have a good one. Thanks, Craig White VP of IT Educational Development Corp 800-475-4522

Hi Craig Try it: dbschema -d mis_db -t "ALL" -ss > mis_db.sch best regards Roberto FERRONATO > To: ids@iiug.org > From: cwhite@edcpub.com > Subject: dbschema errors [12024] > Date: Wed, 7 May 2008 17:23:27 -0400 > > The following command: > > Dbschema -d mis_db -t all -ss > mis_db.sch > > Gives the following error message: > > -284 - A subquery has returned not exactly one row > > It errors at the point that I would expect the indexes to be scripted. I > have dropped the table and indexes in question and it doesn't seem to help. > The sysindexes table doesn't seem to have multiple index rows for this > table. What could be the problem and how do I fix it? When I dropped this > table, I ran a schema that was successful so I do have a good one. > > Thanks, > > Craig White > > VP of IT > > Educational Development Corp > > 800-475-4522 > > > ******************************************************************************* > Forum Note: Use "Reply" to post a response in the discussion forum. > _________________________________________________________________ Explore the seven wonders of the world http://search.msn.com/results.aspx?q=7+wonders+world&mkt=en-US&form=QBRE

Craig, I would try running: oncheck -cdi mis_db > oncheckcdi.mis_db This should give you more info. ----- Original Message ---- From: Craig White <cwhite@edcpub.com> To: ids@iiug.org Sent: Wednesday, May 7, 2008 5:23:27 PM Subject: dbschema errors [12024] The following command: Dbschema -d mis_db -t all -ss > mis_db.sch Gives the following error message: -284 - A subquery has returned not exactly one row It errors at the point that I would expect the indexes to be scripted. I have dropped the table and indexes in question and it doesn't seem to help. The sysindexes table doesn't seem to have multiple index rows for this table. What could be the problem and how do I fix it? When I dropped this table, I ran a schema that was successful so I do have a good one. Thanks, Craig White VP of IT Educational Development Corp 800-475-4522 ******************************************************************************* Forum Note: Use "Reply" to post a response in the discussion forum. ________________________________________________________________________________ ____ Be a better friend, newshound, and know-it-all with Yahoo! Mobile. Try it now. http://mobile.yahoo.com/;_ylt=Ahu06i62sR8HDtDypao8Wcj9tAcJ