At 09:00 AM 29/04/2003 +0200, you wrote:

>Why do I get a " token unknown - line 4 char 4 SET error on the following
>code?
>
>COMMIT WORK;
>SET AUTODDL OFF;
>SET TERM ^ ;
>
>/* Stored procedures */
>
>ALTER PROCEDURE "CLEANMESSAGES"
>AS
>BEGIN
> SET GENERATOR GEN_MSGS TO 0;
> SET GENERATOR GEN_MSGIMPORTS TO 0;
> SET GENERATOR GEN_TXNERROR TO 0;
>
> DELETE FROM MESSAGES;
> DELETE FROM TXNERROR;
> DELETE FROM MESSAGEIMPORTS;
>END
> ^
>
>SET TERM ; ^
>COMMIT WORK;
>SET AUTODDL ON;

SET GENERATOR is a DDL command - you can't use it in a stored procedure or
trigger.

heLen