Declare cursor in dynamic ESQL

We're running Informix 7.1 on Solaris 2.5.1 using the GNU C compiler. No preprocessor or compiler warnings are given. Hardcoding the ESQL statement: EXEC SQL declare cust cursor for select cust_id from custinfo2 where m_org_name like :m_org_name order by m_org_name; works just fine. However, I now need to vary the "where" clause based on several conditions. I assume that using the prepare/execute features of dynamic ESQL is what I want. When I do: sprintf(cmd, "declare cust cursor for select cust_id from custinfo2 where m_org_name like \\"HUNTER\\" order by m_org_name;"); EXEC SQL prepare cmd_id2 from :cmd; EXEC SQL execute cmd_id2; EXEC SQL open cust; I get the following errors: after prepare, SQLSTATE = "42000" (Syntax error or access violation) after execute, SQLSTATE = "37000" (Syntax error or access violation in PREPARE or EXECUTE IMMEDIATE) after open, SQLSTATE = "07003" (Cursor specification cannot be executed) 'cmd' is declared inside a DECLARE SECTION. What am I doing wrong? Is there a better way to go about this? -- Obi-Wan -- Ben "Obi-Wan" Hollingsworth email: bvh@inetnebr.com Vice President and System Administrator voice: (402)434-8680 Internet Nebraska -- Nebraska's on-ramp to the information superhighway