Re: Dynamic SQL compatibility

In article <1992Jan30.191433.20894_at_itx.isc.com> robtu_at_itx.isc.com (Rob Tulloh) writes:
>raghavav_at_cs.rpi.edu (Vijay Raghavan) writes:
>
>>Does any standard exist for Dynamic SQL. In particular is Dynamic SQL as used
>>in Oracle compatible with other RDBMS.
 

>>vijay
>
>My first impression of dynamic SQL in Ingres and dynamic SQL in Oracle
>as they are similar, but far from the same. Especially as you get into
>the manipulation of sqlda structures for binding host variables.
>

  Dynamic embedded SQL will be standardized in SQL2. (I differentiate   dynamic embedded SQL, i.e., PREPARE, EXECUTE, et. al. from actual   dynamic SQL statements , i.e., statements parsed and processed and   optimized at run-time rather than compile time - with the exception   of DB2 and SQL/DS and maybe a few others, certainly NOT Ingres or   Oracle, all SQL statements are executed dynamically - dynamic embedded   SQL is used to contrast it with static embedded SQL even though in   the case of both Oracle and Ingres, both types of embedded SQL are   executed dynamically).

  The issues of incompatibility between binding mechanisms and SQLDAs   is solved with the GET/PUT DESCRIPTOR statements. These hide in   the preprocessor the details of communicating host language issues   to the database. It should be possible to layer a preprocessor   that used a common syntax for host variable bindings and SQLCA/DS   structures on top of any existing actual SQLCA/DA structure.

  Jon Received on Fri Jan 31 1992 - 18:14:29 CET