whbr@ciba-geigy.ch (Hellmuth Broda) (07/19/90)
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 |