Bill64bits wrote:
> This concerns IDS 9.4 TC2 on Windows 2000.
>
> I have one database that recently stopped exporting views from dbexport and
> there are no error messages. It imports fine, but no views.
>
> Also, I notice that when I do dbschema -d database -f all
> Then dbschema aborts after the last stored proc with:
> **
> Illegal SPL Routine Entry
>
> I don't know if these two things are related, but how would one find out
> what is hosed in the database?
>
>
Was the engine upgraded in place from IDS 7.xx? If so the problem may be a
7.xx specific stored procedure that had to be replaced by one compatible
with 9.xx. The old one was renamed to an invalid name but left in place to
ease reversion back to 7.xx. Look for an entry in sysprocedures in each
database that has this problem with a trashed name. You can try getting a
later version of IDS where the problem in dbexport was solved. You can try
using my dbschema replacement utility, myschema. With the -l option it's
output is compatible with dbimport so you should be able to replace the
partial schema file that dbexport left you with one from myschema and
dbimport using that. Myschema is in the package utils2_ak available for
download from the IIUG Software Repository.

Art S. Kagel