[comp.databases] Separate Compilation

marc@sei.cmu.edu (Marc Graham) (02/21/91)

I need to gather information about the ability of commercial DBMS to
support "separate compilation" of application programs. Suppose I
write my application in numerous small pieces (modules, compilation
units, packages) and that more than one of these pieces would like to
do some database calls. Is there anything special I have to do to get
this to work?

For example, I've found that I don't have to do anything special
either with Ingres (v.5.something) or ORACLE (v?). Just code up the
pieces, zip them through the sql preprocessor, the c compiler and ld as
appropriate and it runs, no problem. Even though the pieces use
different communications areas (isqlca in ingres-talk), the DBMS seems
to have no problem in identifying the calls from the different pieces,
using the different ca's, as being from the same transaction.

If you have either positive or negative experience with separate
compilation on any platform, would you please send me a brief note?
Thanks. 

Marc H. Graham                    Software Engineering Institute
marc@sei.cmu.edu                  Carnegie Mellon University
(412) 268 7784                    Pittsburgh, PA   15213
                   

-- 
Marc H. Graham                    Software Engineering Institute
marc@sei.cmu.edu                  Carnegie Mellon University
(412) 268 7784                    Pittsburgh, PA   15213