Translating with DrWatson… this can take a few seconds the first time.
This is a genuine, complex translation. DrWatson protects commands, error codes, and log output while naturally translating the surrounding text. It’s translated once and saved.
Lloyd AJ Wilson — — source: Informix-list mailing list archive (1991-1998)
Hi All,
Running dbschema -t <table> -d <database> -ss encounters the -284 error: A
subquery has returned not exactly one row
Can some explain a bit what dbschema is trying to do here ...
We also get the -100 Error: which is ISAM error: duplicate value for a
record with unique key
We are encountering this all over the place for our client mostly running on
the Alpha servers. Most likely they are running version 4 and up.
This problem has been documented with Informix as a bug I believe. Not sure
... in any case ... does anyone have a resolve to this issue. It is quite
cumbersome for these errors to occur on more than 100 tables in our database
which contains over 300 tables.
I am running out of time ... and dropping and recreating tables and indexes
seems to resolve the duplicate error problem but does not always solve the
issue with the subquery problem.
If you can ... it would be helpful to know a bit more about what dbschema is
trying to do ... the tables it pulls from and such ... because I am at a
lost to a resolve other than what I mentioned.
TIA,
Lloyd Aj Wilson
We use strictly necessary cookies to make this site work. With your
consent we’d also use optional cookies for analytics and marketing. You can accept all,
reject all, or choose. Read our Cookie Policy.