SQL vs. 4GL

Posted in 1992

Walt Hultgren {rmy} — Thu, 6 Feb 92 23:50:20 -0500 — source: Informix-list mailing list archive (1991-1998)

Path: emory!att!linac!uwm.edu!ux1.cso.uiuc.edu!news.iastate.edu!wemhoff From: wemhoff@cs.iastate.edu (Becky Wemhoff) Newsgroups: comp.databases.informix Keywords: SQL, 4GL, standards Message-ID: <wemhoff.697427191@judy.cs.iastate.edu> Date: 7 Feb 92 01:46:31 GMT Sender: news@news.iastate.edu (USENET News System) Organization: Iowa State University, Ames IA I'm working in a new Informix shop, and there's a minor debate going on here about when to use SQL code only and when to use 4GL code. We all agree that a simple one-time-only report will be SQL'ed. However, our current 4GL guru would like everything else written in 4GL. The SQL guru thinks that the code would be simpler and easier to maintain if we could write most of our applications in SQL. Assume anything else that you would like. Memory is not a problem. We want a GUI user interface but haven't decided on anything yet. All I would like is a discussion (horror stories :-) on pros/cons of the two products. Thanks!