When gbak -I used in my DB, there is an error appears, see below. And restored database does not contain ANY stored procedures.
Error while parsing procedure HP_INSERT_FIOLIST's BLR.
index FIOLIST_NAME1 cannot be used in the specified plan.
there is no index FIOLIST_NAME3 for table FIOLIST.
unknown ISC error 336330835.
I suppose, the reason of this error is usage of PLAN clause in stored procedure queries. Procedure HP_INSERT_FIOLIST contains code below:
where fl_name1 = :txt1 and
fl_name2 = :txt2 and
fl_name3 = :txt3
PLAN (fiolist index (fiolist_name1, fiolist_name2, fiolist_name3))
The proposal is to ignore saved query plan in the stored procedure source, when command line switches -I or -M used.
The warning message can be enough.