Re: Dynamic SQL vs. ESQL/C

Jonathan, Thanks for your reply. In message <199607181555.IAA07648@anubis.informix.com> you write: >(1) How do you propose to call dynamic SQL from C? ESQL/C. >(2) ESQL/C is a thin layer which translates SQL code into C. Yes. I did not express my original question well. The two options I am looking at are: 1. ESQL/C in which the sql is known at compile time and hard coded. 2. ESQL/C in which the sql is constructed and 'prepare'd at runtime. I am not going to call the ESQL/C library functions directly or anything fancy/stupid like that! I expected option 1 to be faster but that is not what my initial testing is showing. Why? Thanks again, --Joan