Path: utzoo!attcan!uunet!zephyr.ens.tek.com!uw-beaver!mit-eddie!bloom-beacon!eru!luth!sunic!mcsun!cernvax!chx400!cgch!news
From: whbr@ciba-geigy.ch (Hellmuth Broda)
Newsgroups: comp.databases
Subject: Concurrent DB access 4GL and 3GL?
Message-ID: <1990Jul19.141746.5903@ciba-geigy.ch>
Date: 19 Jul 90 14:17:46 GMT
Sender: news@ciba-geigy.ch (USENET News Agent)
Organization: c/o CIBA-GEIGY Ltd, Agro Informatics Agency, CH-4002 Basel, Switzerland
Lines: 32

We are planning to use the identical databases and tables on our
Teradata DBC/1012 in a mixed software environment.  Before we install
new software we want to make sure that a fourth-generation-language
(4-GL) product like SQL-forms (ORACLE) that accesses the TD via CLI can
live together with 3-GL applications that use the embedded SQL
environment.

	Do you have experiences with concurrent access of both software
	worlds or do you have references to such installations?

	Is table/record locking a problem?  E.\,g. one tool is in an
	{\tt update} on a table while the other tool concurrently
	issues an {\tt insert}.  Will SQL-forms use the same locking
	mechanisms as the embedded SQL in a 3-GL application?

	Do 4-GL tools on top of the TD use proprietary locking
	mechanisms that cannot be accessed by 3-GL applications?

	Can both worlds use the (same) 4-GL data dictionary?  Will
	e.\,g.  triggers in the 4-GL tool be accessible by 3-GL
	applications?

Since major decisions in project and software architecture are
dependent on this problem we need answers ASAP.

Any further suggestions concerning this problem are welcome.

--
,___________________________________________________________________________,
| Dr.rer.nat. Hellmuth W. Broda  | VOICE:    +4161 697-7109 FAX: ...697-3288|
| c/o CIBA-GEIGY Ltd.; Div. AGRO | UUCP:     ..!uunet!mcsun!chx400!cgch!whbr|
|     AG-Informatics Agency      | INTERNET: whbr@ciba-geigy.ch             |