Re: static/dynamic/embedded SQL distinctions

Dynamic SQL is made up on the fly by a procedure or end user as a string contianing SQL statements. The ANSI Standards have PREPARE and EXECUTE statements for this. Microsoft and other vendors will do it differently, but it is the same idea. Like having Query Analyzer in your program -- and just as dangerous.

Embedded SQL is placed inside a host program, not built on the fly. Its statements begin with the keywords "EXEC SQL <sql code>" . A preprocessor converts these statements into API or CLI calls appropriate for the host language.

Static SQL is simply native SQL code. Since SQL has to exist in a host program to talk to the outside world, it will be embedded somewhere. Or it can be part of a trigger, stored procedure, etc.

You missed the SQL/CLI, ODBC, JDBC, etc. which are call level interfaces from host languages to an SQL database.

. Received on Mon Aug 22 2005 - 15:00:28 CDT