At 09:03 AM 2/04/2007, you wrote:

>I'm getting this error, and I'm not sure why:
>
>Dynamic SQL Error.
>SQL error code = -204.
>internal gds software consistency check (table JOB).
>
>What does this typically mean?

Well, the one thing that this error is NOT is "typical". It occurs
when the engine encounters an error condition it doesn't recognise
and/or can't fix itself. If possible (as here) it will try to
provide a clue as to where it struck the problem.

Some things to consider:

If the exception goes away after shutting down and restarting the
database, it might indicate a memory or disk fault, esp. if you get
further such errors with different DB objects offered as clues.

If you're not using Fb 2.0, is it possible that you've hit the
deathly limit on no. of rows in a table (albeit that's a pretty high number!)

Has anyone been tinkering with the metadata for this table, or any
dependent objects, directly?

Did someone do an ALTER TABLE or other DDL op on this table or a
dependent object and then try to feed in some data in the same
uncommitted transaction?

Could you be running out of disk space (or hitting the filesystem
file size limit, if you're using FAT32 or old NT4 partitions)?

Are you able to backup and restore the database?

./heLen