Path: utzoo!utgpu!news-server.csri.toronto.edu!cs.utexas.edu!uunet!decwrl!ucbvax!ecs.southampton.ac.uk!S.P.Q.Rahtz
From: S.P.Q.Rahtz@ecs.southampton.ac.uk (Sebastian Rahtz)
Newsgroups: comp.lang.icon
Subject: Re: Icon as RDBMS report writer language
Message-ID: <5187.9010031441@manutius.ecs.soton.ac.uk>
Date: 3 Oct 90 14:41:36 GMT
References: <9010031337.AA01510@cherry04.cray.com>
Sender: daemon@ucbvax.BERKELEY.EDU
Distribution: inet
Organization: The Internet
Lines: 19

"David S. Cargo" writes:
 > problem report data base using ORACLE.  My section in Cray likes to see
 > reports about our status weekly.  Using canned and dynamically
 > generated queries, I extract a formatted report that I then feed to an
 > Icon program for further processing.  The further processing in this
 > case means extracting data and rewriting it with LaTeX code and macro
 > calls defined in the tables.sty file.  The result is formatted with
I have a large Ingres database of gravestones and inscriptions, and I
used to have an Icon program to fiddle with the output, as in the
example above. then I realized that a lot of the same work could be
done in LaTeX itself...; so Icon now has no place in the scheme. This
is because I have to the database searching with a C program with
embedded SQL which is linked to Ingres libraries. What I would really
like to do, of course, is to write my program in Icon with embedded
SQL. I don't suppose anyone has done this by any chance? the idea of a
generator which returned tuples from the database is rather
attractive.

Sebastian Rahtz