Relay-Version: version B 2.10 5/3/83; site utzoo.UUCP Path: utzoo!mnetor!uunet!lll-winken!manatt From: manatt@lll-winken.ARPA (Doug Manatt ) Newsgroups: comp.databases Subject: Flaw in RTI ingres Message-ID: <640@lll-winken.ARPA> Date: Wed, 19-Aug-87 00:40:18 EDT Article-I.D.: lll-wink.640 Posted: Wed Aug 19 00:40:18 1987 Date-Received: Fri, 21-Aug-87 00:52:36 EDT Organization: Lawrence Livermore Labs, Livermore CA 94550 Lines: 17 Keywords: Update impossible I have been working with RTIs ingres for some time now, but have only just noticed what I consider a serious flaw in the functionality that it provides. From all I know about it, it is impossible to have their RDBMS provide your program with a row of your data, allow you program to transform it and the replace the transformed data in the same table in place of the original data. Their RDBMS provides a "REPLACE" capability, but only replaces that can be computed in the "BACKEND" are allowed. The other alternatives are to load the rows to be worked on into arrays, temporary files, or "form" structures. If I am missing something simple, please send me mail, but if this is actually so please comment in news if this is the general situation for other products, or if this is for some reason desirable. Doug Manatt LLNL (415)422-7257 manatt@lll-winken.arpa