Nigel,

> set term !! ;
> CREATE PROCEDURE sp_ins_tablename(
> F1 integer,
> F2 VARCHAR(20),
> F3 VARCHAR(20)
> ) RETURNS (
> int_newkey NUMERIC(18,0)
> )
> AS BEGIN
> /* Get a new generator value */
> int_newkey = gen_id(generator_name,1);
> /* Insert it into the table */
> insert into table (pkeyfield, F1, F2, F3)
> values (:int_newkey,:F1, :F2, :F3);
> SUSPEND; <-------------------------------------

As I know (may be inaccurate) there is no need to put SUSPEND here in this
procedure.

> END !!
> SET TERM ; !!

Best Regards
Bogusław Brandys