Xref: utzoo comp.databases:2572 comp.lang.misc:2956 comp.software-eng:1541
Path: utzoo!attcan!utgpu!jarvis.csri.toronto.edu!mailrus!tut.cis.ohio-state.edu!ucbvax!agate!violet.berkeley.edu!steve
From: steve@violet.berkeley.edu (Steve Goldfield)
Newsgroups: comp.databases,comp.lang.misc,comp.software-eng
Subject: Re: need help choosing between INGRESS and PROGRESS
Keywords: INGRESS, PROGRESS
Message-ID: <24574@agate.BERKELEY.EDU>
Date: 18 May 89 15:00:30 GMT
References: <985@resource.UUCP> <309@viusys.UUCP> <24295@agate.BERKELEY.EDU> <1932@ssc.UUCP> <3295@tank.uchicago.edu>
Sender: usenet@agate.BERKELEY.EDU
Distribution: na
Organization: University of California, Berkeley
Lines: 39

In article <3295@tank.uchicago.edu> monty@delphi.UUCP (Monty Mullig) writes:
#>
#>fyl@ssc.UUCP (Phil Hughes) writes:
#>
#>	In article <24295@agate.BERKELEY.EDU>, steve@violet.berkeley.edu
#>	(Steve Goldfield) writes:
#>	> I haven't used PROGRESS, but I can confirm the weakness
#>	> of Ingres' report writer.
#>	>
#>	> First of all, it is limited to a single retrieve
#>
#>	Yuck.  This is not a problem with Progress.  How can you have a
#>	real relational database if you can't retrieve stuff from
#>	multiple tables?
#>
#>well, now, wait a minute.  sure, ingres is disappointing in a number
#>of ways, but the idea that you can use only one table in the report
#>writer just isn't true.  what we have here, i think, is a failure to
#>communicate.  ingres allows only one SELECT statement in the report
#>writer, but of course that SELECT statement is a full featured SELECT
#>and can include joins to other tables.
#>
#>--monty

You may have missed my earlier response to this point.

1. I am discussing Ingres 5.0 which is all we've got (and that
   will soon be phased out here, too).

2. The Ingres Report-Writer reference manual states quite
clearly, on page 4-8, "Only one .query command is permitted
for a report, and only one data retrieval statement is
permitted within the .query command." So, while that single
retrieval statement may, presumably, join several tables,
it didn't do me any good when I needed to append from two
tables and then join from other tables. This restriction
is a severe one.

Steve Goldfield