Variables in EXECUTE PROCEDURE statement

Posted in 1997

Neil Truby — Wed, 22 Jan 1997 08:39:23 +0000 — source: Informix-list mailing list archive (1991-1998)

Our third-party vendor has supplied a procedure to delete rows in a table older than a specified DATETIME, e.g.: execute procedure delete_logs('1997-01-15 00:00:00') But how can I put a variable in the above SQL?: execute procedure delete_logs(TODAY - 7) fails with a "non-numeric character" message. Thanks Neil Truby