Problem: How to create a static query to exist and be optimized on the server for repeated usage. Problem: I dont know how to create a stored procedure. Solution: Example: SET TERM !!; CREATE PROCEDURE my_procedure RETURNS (a_value INTEGER) AS BEGIN SELECT count(*) FROM table_name; END !! SET TERM ;!! Use the Stored Procedure: SELECT * FROM my_procedure
Last Modified: 29-SEP-00