[comp.databases] Jam/DBi: How does it work?

rudoff@MDI.COM (Doug Rudoff) (01/31/91)

I have seen JAM in action and have some literature on JAM/DBi, but I'm
not quite sure how JAM/DBi works.

I get the impression that it starts up a database process and sends SQL
queries to it, and somehow reads in the returns and passes it back
into the executable C code. Is this correct? Or, does it require the
use of a embedded SQL in the code?

I would be using JAM with Informix on a DEC 5810 running Ultrix,
mainly to find something more powerful than sperform to handle forms.

If JAM/DBi doesn't use embedded SQL, can it be used as a replacement
for it?

If someone has some source code generated by JAM/DBi, I would be
interested in seeing it.

My main goal is to convince my supervisor that we need something more
powerful and flexible than C-ISAM to access our database.
-- 
-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=
Doug RUDOFF    Motorola Mobile Data    Bothell, WA    uunet!mdisea!rudoff
                                                           rudoff@mdi.com
-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=

drack@titan.tsd.arlut.utexas.edu (Dave Rackley) (01/31/91)

In article <1991Jan31.002416.24897@MDI.COM> rudoff@MDI.COM (Doug Rudoff) writes:

>   I have seen JAM in action and have some literature on JAM/DBi, but I'm
>   not quite sure how JAM/DBi works.

>   I get the impression that it starts up a database process and sends SQL
>   queries to it, and somehow reads in the returns and passes it back
>   into the executable C code. Is this correct? Or, does it require the
>   use of a embedded SQL in the code?

JAM/DBi adds SQL commands to its procedural language (JPL), which works much
like an interpreted language.  In fact the JPL can be stored in flat, ASCII
files and "called" from within a window.

[stuff deleted]

>   If JAM/DBi doesn't use embedded SQL, can it be used as a replacement
>   for it?

I tested JAM/DBi with Oracle--it seems to be a fair replacement for embedded
SQL.  However, one must still write queries, since JAM/DBi doesn't generate
queries.

>  If someone has some source code generated by JAM/DBi, I would be
>  interested in seeing it.

JAM/DBi (for Oracle) doesn't produce source code!

For more info:      JYACC (JAM) Sales, 800-458-3313

BTW I have no connection with JYACC, except as a customer.


--

  DISCLAIMER:  I, hereby, disclaim any disclaimer except this disclaimer.  

+=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=+
| David Rackley                 | Now comes the really weird part...You know  |
| Applied Research Laboratories | the part where I know how to tap dance, but |
| The University of Texas       | only while wearing golf shoes...            |
| Austin, TX.  78758            |        ...Ponderous, man, really ponderous! |
+=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=-=+