Path: utzoo!utgpu!news-server.csri.toronto.edu!mailrus!wuarchive!mit-eddie!uw-beaver!sumax!quick!amc-gw!thebes!campbell
From: campbell@Thalatta.COM (Bill Campbell)
Newsgroups: comp.databases
Subject: Re: Comments in SQL scripts -- is there standard
Summary: Use C-Preprocessor in front of SQL
Keywords: SQL UNIFY cpp gcc
Message-ID: <4944@thebes.Thalatta.COM>
Date: 13 Jul 90 14:34:57 GMT
References: <216@cti1.UUCP>
Reply-To: campbell@Thalatta.COM (Bill Campbell)
Organization: Celestial Software, Mercer Island, WA
Lines: 15

I've sort of cheated here.  I pass all my SQL scripts through
gcc-cpp before SQL ever sees it (and RPT too) giving me full
#include file capabilities, macro expansion, C-comments, and
conditional scripts using #ifdef...

The same program is used for SQL and RPT calling the appropriate
program in UNIFY when the final script has been built.

This doesn't work with SQL when run interactively, but does for
all scripts run from shell scripts or UNIFY's SQL by Forms.
-- 
....microsoft--\                    Bill Campbell; Celestial Software
...uw-entropy----!thebes!camco!bill 6641 East Mercer Way
....fluke------/                    Mercer Island, Wa 98040
....hplsla----/                     (206) 232-4164