Re: Dynamic SQL vs. ESQL/C

In article <31EF1C43.3B4E@informix.com> davek@informix.com writes: >I'm afraid I have to mildly disagree with my esteemed and learned >colleague here. While it certainly depends on how one uses the various >statements, the most common approach to non dynamic esql/c is along >the lines of: I'm afraid I have to mildly disagree with my esteemed and learned colleague Dave. Your answer is colored somewhat by the Informix view of the world with respect to static and dynamic SQL. Relative to the more classic definitions of those terms, all Informix SQL via ESQL/C is dynamic. The classic definition of static SQL includes the notion of completely parsing, verifying the statement, creating an access plan etc. during the compile process. Usually some sort of identifiers are assigned and registered in the database. Upon execution of the application, the identifiers are used. This is similar to the state that is reached after a successful prepare during Informix's always dynamic mode of operation. The pure static handling described above is implemented on DB2 on IBM mainframes for example. Of course Dave is right that the use/non-use of descriptors vs. host variables etc does have some impact, but again these issues are still within the domain of dynamic sql. Scott