Path: utzoo!utgpu!watmath!att!tut.cis.ohio-state.edu!bloom-beacon!usc!bbn!oliveb!amdahl!rtech!squid!robf
From: robf@squid.rtech.com (Robert Fair)
Newsgroups: comp.databases
Subject: Re: SQL-schema to C generation
Message-ID: <3306@rtech.rtech.com>
Date: 7 Aug 89 12:18:01 GMT
References: <1910007@hpmcaa.mcm.hp.com>
Sender: news@rtech.rtech.com
Reply-To: robf@squid.UUCP (Robert Fair)
Organization: Relational Technology, Inc.
Lines: 20

>From: nacer@hpmcaa.mcm.hp.com (Abdenacer Moussaoui)
>(wants a  SQL schema to C declaration  generator)

Several RDBMS products have a utility called DCLGEN which takes
SQL schema information, and generates #include files containing:
- ESQL DECLARE TABLE statements
- Host language structure definitions for  each table specified, with
  the appropriate field names, types etc.

The INGRES version of DCLGEN can  generate code for any of the supported
3GLs (C, ADA, BASIC,...) and handles  things like alternate structure
names, output files etc.

If your DBMS doesn't have DCLGEN or equivilent its pretty easy to write
your own using ESQL, as long as there is a queryable set of system catalogs
(which just about any decent DBMS should have).

Robert Fair
Technical Support
Relational Technology, Inc