I'm a SQL Server guy so forgive the ignorance here. I'm trying to
embed a SELECT statement into a Stored Procedure, but it won't
compile. If I take the SELECT statement out it compiles no
problem. Can one of you folks please help? Thanks.

COMMIT WORK;
SET AUTODDL OFF;
SET TERM ^ ;

/* Stored procedures */

ALTER PROCEDURE "TEST"
AS
BEGIN

SELECT * FROM IPCSENSOR;

EXIT; END
^

SET TERM ; ^
COMMIT WORK;
SET AUTODDL ON;