Peter,

I've seen this done on a group of systems.  I write my program to call
sDbGet (passing the function appropriate arguments and the address of the
buffer to store the returned record) and it returns a short integer zero if
successful or the error code if not.  sDbGet, then, is calling the DBGET
intrinsic to access an IMAGE database on my MPE system.

The idea is that if I have to change what database (say Eloquence on a 9K,
instead of IMAGE on a 3k) I'm accessing, the change is done in the function
I'm calling, not in the program I've written, though a recompile may be in
order to handle this "seemlessly".  Regardless, the function I'm calling and
the database it's accessing still have to follow the rules of that DB/RDBMS,
but the program I wrote still calls the same function.  What the function is
doing changes based on the system it's on, the database it's accessing, the
connection path to that database, etc.

Yes, an IMAGE app on an MPE system can update an SQL database, so long as
the functions it's calling can connect, lock, insert, and release the
database according to its rules.  The nomenclature "IMAGE APP" is misleading
because if it's not performing its activities against an IMAGE database,
technically it isn't an "IMAGE" application.  The same code that calls
sDbGet for an IMAGE database on an MPE box, however, can just as easily read
an SQL database on a wintel machine if the sDbGet function is written to
handle it.

I'm not touching question three.  No sir, not gonna do it.

Rs~

Russ Smith
* * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * *
* * * * * *
The opinions expressed in this email are mine, and are not meant to reflect
those of any other party.  The subject matter herein is intended solely for
the named recipient(s) of this email.  Spellcheck cancelled.  Your mileage
may vary.  Look both ways and hold hands when you cross the street.
* * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * * *
* * * * * *


----- Original Message -----
From: "Peter Smithson" <[log in to unmask]>
To: <[log in to unmask]>
Sent: Tuesday, August 24, 2004 5:17 AM
Subject: [HP3000-L] Intercepting image calls and sql server synchonisation.


> Hi,
>
> I've got three questions -
>
> 1) If you write your own library with all the image calls in it, I know
> how to make a COBOL program call that instead of the real image library.
> But, can my intercept library then call the real image library?
>
> 2) Is there a way to have your image app on MPE automatically update an
> sql server database?
>
> 3) Is there even a sql server client for MPE?
>
> Just thinking about solving (2) by using (1) in a cunning way.  (I've
> got a way round (3) but it'd be handy to have).
>
> Cheers
>
> Peter
> --
> http://www.beluga.freeserve.co.uk
>
> * To join/leave the list, search archives, change list settings, *
> * etc., please visit http://raven.utc.edu/archives/hp3000-l.html *

* To join/leave the list, search archives, change list settings, *
* etc., please visit http://raven.utc.edu/archives/hp3000-l.html *