Subject isql metadata extraction and script execution
Author iananewby
Hi All,
I am currently exreacting meta data for inclusion into CVS. I have
noticed that the meta data extraction in isql (windows, Firebird RC2
dialect 1 database) puts a SET AUTODDL OFF before stored procedures
are created and a SET AUTODDL ON after stored procedures are
modified.

If I run this script to create a new database the server crashes
on the SET AUTODDL ON line. Should there be another pair of OFF/ONs
and a commit between the CREATE PROCEDURE and the ALTERPROCEDURE?

If I remove all the SET AUTODDL ... commands the database restores
correctly.

Another gripe, is there any way of sending both the output and the
errors from isql into the same file so It is possible to find which
lines cause the problems?

Regards
Ian Newby