Informix Prepared Statements

Posted in 2007

lisa_0801@yahoo.com — 5 Mar 2007 08:02:48 -0800 — source: Usenet: comp.databases.informix

I'm trying to create the below sp in informix but i'm getting a syntax error which points to the prepare statement. Please help! CREATE PROCEDURE test() DEFINE sSQL CHAR (100); LET sSQL = "select * from test"; PREPARE STATEMENT1 FROM sSQL END PROCEDURE;