I tried the following:

1. isql -extract -output gms1.sql grantmgt.gdb
2. added to statements to script

SET SQL DIALECT 2;
OUTPUT RESULTS.TXT;
CREATE DATABASE 'D:\100\Grantmgt.gdb'
USER 'SYSDBA' PASSWORD 'masterkey'
PAGE_SIZE 4096;

3. isql -i

The ISQL output only suggested problems with four triggers. These
triggers work in Dialect 1 and do not seem to be related to the
errors I am seeing in stored procedure executions. Moreover, I do not
understand the problem with these triggers. An example of the ISQL
Dialect 2 problem with one of the four triggers is below:

**** Error preparing statement:

CREATE TRIGGER APPLICATION_AI_EDIT_LOG FOR APPLICATION
ACTIVE AFTER INSERT POSITION 1
as
DECLARE VARIABLE InsertID INTEGER;
DECLARE VARIABLE InsertSUBMITDATE DATE;
DECLARE VARIABLE InsertPROJECTYEAR CHAR(2);
DECLARE VARIABLE InsertSTARTDATE DATE;
DECLARE VARIABLE InsertENDDATE DATE;
DECLARE VARIABLE InsertAPPLICANTNAME VARCHAR(80);
DECLARE VARIABLE InsertIMPLEMENTINGORG VARCHAR(80);
DECLARE VARIABLE InsertPROJECTDIRECTOR VARCHAR(35);
DECLARE VARIABLE InsertFISCALOFFICER VARCHAR(35);
DECLARE VARIABLE InsertFEDFUNDS NUMERIC(15,2);
DECLARE VARIABLE InsertSTATEFUNDS NUMERIC(15,2);
DECLARE VARIABLE InsertSTATEMATCH NUMERIC(15,2);
DECLARE VARIABLE InsertLOCALMATCH NUMERIC(15,2);
DECLARE VARIABLE InsertPRIVATEMATCH NUMERIC(15,2);
declare variable InsertSTATUS CHAR(1);
DECLARE VARIABLE CriticalFieldChanged integer;
BEGIN
InsertID = GEN_ID(EDITS_APPLICATION,1);
InsertSUBMITDATE = new.submitdate;
InsertPROJECTYEAR = new.PROJECTYEAR;
InsertSTARTDATE = new.STARTDATE;
InsertENDDATE = new.ENDDATE;
InsertAPPLICANTNAME = new.APPLICANTNAME;
InsertIMPLEMENTINGORG = new.IMPLEMENTINGORG;
InsertPROJECTDIRECTOR = new.PROJECTDIRECTOR;
InsertFISCALOFFICER = new.FISCALOFFICER;
InsertFEDFUNDS = new.FEDFUNDS;
InsertSTATEFUNDS = new.STATEFUNDS;
InsertSTATEMATCH = new.STATEMATCH;
InsertLOCALMATCH = new.LOCALMATCH;
InsertPRIVATEMATCH = new.PRIVATEMATCH;
InsertSTATUS = new.applstatuscode ;
INSERT INTO EDITSAPPLICATIONTABLE
(ID,
APPLICATIONNBR,
EMPID_LASTUPDATE,
DATEOFEDIT,
SUBMITDATE,
PROJECTYEAR,
STARTDATE,
ENDDATE,
APPLICANTNAME,
IMPLEMENTINGORG,
PROJECTDIRECTOR,
FISCALOFFICER,
FEDFUNDS,
STATEFUNDS,
STATEMATCH,
LOCALMATCH,
PRIVATEMATCH,
STATUS)
VALUES(
:InsertID,
new.applicationnbr,
new.empid_lastupdate,
'NOW',
:InsertSUBMITDATE,
:InsertPROJECTYEAR,
:InsertSTARTDATE,
:InsertENDDATE,
:InsertAPPLICANTNAME,
:InsertIMPLEMENTINGORG,
:InsertPROJECTDIRECTOR,
:InsertFISCALOFFICER,
:InsertFEDFUNDS,
:InsertSTATEFUNDS,
:InsertSTATEMATCH,
:InsertLOCALMATCH,
:InsertPRIVATEMATCH,
:InsertSTATUS);
END

--- In ib-support@y..., Thomas Miller <tmiller@b...> wrote:
> You may want to try dialect 2. This is suppose to report problems
that
> will effect a database
> when migrating from dialect 1 to dialect 3.
>
> stevenggibb wrote:
>http://www.bss-software.com