Path: utzoo!attcan!utgpu!jarvis.csri.toronto.edu!clyde.concordia.ca!uunet!van-bc!rsoft!mindlink!a218 From: a218@mindlink.UUCP (Charlie Gibbs) Newsgroups: comp.sys.amiga Subject: Re: SQL Database(s) Message-ID: <790@mindlink.UUCP> Date: 12 Dec 89 19:35:46 GMT Organization: MIND LINK! - British Columbia, Canada Lines: 35 In article rosenber@ra.abo.fi (Robin Rosenberg INF) writes: > There is a Public Domain version of Ingres. The system includes all >source and the query language QUEL (definitely not as nice as SQL). Tell me more. Where can I find it? We're running Ingres on our Unix box here at work; a PD version for the Amiga might be interesting. On another subject, does anyone know anything about embedded SQL in Ingres user programs? As part of our conversion to Unix, we're considering moving all of our existing files into Ingres, but we need some way to convert our existing COBOL programs to access them. Apparently user programs containing embedded SQL statements can be run through a pre-compiler which converts them to equivalent calls to Ingres in the native language (COBOL, C, FORTRAN, etc.). The snag is that Ingres doesn't offer a COBOL pre-compiler for the Unisys 5000/85, which we are using. (Since the pre-compiler must basically be a filter which converts embedded SQL to COBOL while passing the rest of the program through unchanged, you'd think that they could write it in a sufficiently portable manner that it would just take a re-compile.) If I could figure out what COBOL calls correspond to various embedded SQL statements, I could probably roll my own rudimentary pre-compiler, or just code the COBOL calls directly. Does anyone have such information? We'd really like to convert our existing data files to Ingres, because they could then be integrated with the files produced by the new GIS (geographical information system) running on the Unix box. Any assistance would be greatly appreciated. Charlie_Gibbs@mindlink.UUCP I'm looking for the stationery department but they keep moving it.