Hi Tim,

> How do I do the following ?:
>
> CREATE PROCEDURE INITIALIZE_TRANSTYPES
> AS
> BEGIN
> SET GENERATOR "GEN_TXNTYPE" TO 0;
> END
>
> When I try to create the Stored Procedure, I get the following error :
>
> SQL error code = -104
> Token unknown - line 4, char 4
> SET

You've answered your own question: no, you cannot.

DDL isn't allowed in Firebird.

With Fb1.5, you can do this via the EXECUTE STATEMENT construct.

With regards,

Martijn Tonies
Database Workbench - developer tool for InterBase, Firebird & MS SQL Server.
Upscene Productions
http://www.upscene.com