Re: SQL vs. 4GL

Path: emory!swrinde!elroy.jpl.nasa.gov!ames!agate!linus!linus!mwvm.mitre.org!M22367 From: M22367@mwvm.mitre.org Newsgroups: comp.databases.informix Message-ID: <1678DC164.M22367@mwvm.mitre.org> Date: 14 Feb 92 18:45:01 GMT References: <wemhoff.697427191@judy.cs.iastate.edu> <10087@gollum.twg.com> Sender: news@linus.mitre.org (News Service) Organization: The MITRE Corporation, McLean VA 22102 Nntp-Posting-Host: mwvm.mitre.org (Buncha Stuff Deleted) > >For my two cents worth, I'd like to see a program which would find all of >the programs which need to be recompiled when I modify a particular table. > I used to work with ADR (now CA) Datacom's development environment IDEAL. Whenever you created a 4gl program, you had to fill in (on line) a list of "Resources" that the program was going to use, including tables/views, screens and reports. When you compiled the code, if you made reference to an item that was not listed as a resource, you got a compile error. More to the point, their were (are) system reports that list everything that is dependent on an object. Change a screen? a view? a report? Before you do, check what impact this will have on existing systems. If you *do* make a change and then try to use an object that depends on the old version, the system stops you. "<object type, name> has been changed since you last used it!" This kind of robust configuration management can be put together using any (?) rdbms if you want to invest the time and energy. Sure did love that IDEAL... - Mike This looks like a good place to put in the standard disclaimers about this stuff being my opinion only. My employer thinks I'm doing something else.