Path: utzoo!utgpu!news-server.csri.toronto.edu!cs.utexas.edu!uunet!cimshop!davidm From: cimshop!davidm@uunet.UU.NET (David S. Masterson) Newsgroups: comp.object Subject: Re: Object-Oriented COBOL? Message-ID: Date: 26 Nov 90 01:56:09 GMT References: <679@dlogics.COM> <684@dlogics.COM> Sender: davidm@cimshop.UUCP Distribution: comp Organization: Consilium Inc., Mountain View, California. Lines: 33 In-reply-to: dsa@dlogics.COM's message of 20 Nov 90 20:38:27 GMT X-Posting-Software: GNUS 3.12 [ NNTP-based News Reader for GNU Emacs ] >>>>> On 20 Nov 90 20:38:27 GMT, dsa@dlogics.COM (David Angulo) said: dsa> Yes, but you really want to avoid dynamic SQL if at all possible. dsa> Anyway, if you use dynamic SQL, won't you really be giving control of the dsa> class's inner variables to the outside thus destroying your dsa> encapsulation??? This is what Ed was talking about from the beginning. Probably true that I am not getting around the problems that Ed was talking about. I need to think about that. However, on the question of dynamic SQL, if you start the derivation tree of tables from a base Table class that is implemented as doing everything via dynamic SQL, then each new DerivedTable class can overload the operations normally done with dynamic SQL using static SQL. Initially, your system would perform slowly, but it should be able to perform everything needed, because of the dynamic SQL capabilities. As performance analysis dictates, functions currently done by building dynamic SQL strings and calling base Table functionality can be replaced with static SQL operations. From a development standpoint, minimal effort is required to get all functionality and then a steady effort is required to improve the performance of that functionality. Of course, the problem is determining the initial set of operations to put onto Table. Table would probably equate to the List functions I previously talked about in that its operations would produce a list of Tuples. There's probably a friendly relationship (or two or three) in there between Table and Tuple{List}. -- ==================================================================== David Masterson Consilium, Inc. (415) 691-6311 640 Clyde Ct. uunet!cimshop!davidm Mtn. View, CA 94043 ==================================================================== "If someone thinks they know what I said, then I didn't say it!"