pg.ddx.io  pgsql-general@postgresql.org mailing list archive  
help / color / mirror / Atom feed
COBOL PRECOMPILER for PostGreSQL
2+ messages / 2 participants
[nested] [flat]

* COBOL PRECOMPILER for PostGreSQL
@ 2024-01-13 05:39  Chuck Haatvedt <chuck.haatvedt@gmail.com>
  0 siblings, 1 reply; 2+ messages in thread

From: Chuck Haatvedt @ 2024-01-13 05:39 UTC (permalink / raw)
  To: pgsql-general; +Cc: Simon Sobisch <simonsobisch@gnu.org>

<!DOCTYPE html>
<html>
  <head>

    <meta http-equiv="content-type" content="text/html; charset=UTF-8">
  </head>
  <body>
    <font size="4" face="Courier New">Hello,<br>
      <br>
      I'm working with the opensource GNUCOBOL project. One of our
      efforts is to provide a migration path for organizations to move
      from commercial COBOL compilers to GNUCOBOL. One of the
      impediments to this migration is to move from an Oracle or IBM
      RDBMS solution to PostGreSQL. Most organizations are using one of
      these RDBMS solutions with COBOL precompilers supplied by the
      vendor and have embedded SQL in their source code. This represents
      a significant challenge to any migration as there is not a COBOL
      precompiler for PostGreSQL.<br>
      <br>
      I would like to propose that the ECPG precompiler for C, to be
      modified to accept either C or COBOL. Another option would be to
      clone ECPG to work with the COBOL language. For the most of the
      COBOL variable types it should not be too difficult to convert
      them to C variables which would reduce the effort. Both of these
      RDBMS use the syntax similar to C, EXEC SQL ..... END-EXEC, where
      text between them is the actual SQL statement or variables.<br>
      <br>
              Thanks for your consideration,<br>
    </font>
    <div class="moz-signature">-- <br>
      <meta http-equiv="content-type" content="text/html; charset=UTF-8">
      <title></title>
      <meta name="generator" content="LibreOffice 6.4.3.2 (Windows)">
      <meta name="created" content="2008-08-29T00:00:00.021010100">
      <meta name="changed" content="2020-04-24T14:16:55.044000000">
      <style type="text/css">
		@page { margin: 0.79in }
		p { margin-bottom: 0.08in }
	</style>
      <p style="margin-bottom: 0in"><font
          face="Monotype Corsiva, cursive"><font style="font-size: 18pt"
            size="5"><span style="background: #ffffa6">Chuck
              Haatvedt</span></font></font></p>
      <p style="margin-bottom: 0in"><font face="Courier New, monospace"><font
            style="font-size: 14pt" size="4"><span
              style="background: #ffffa6"><a class="moz-txt-link-abbreviated" href="mailto:chuck.haatvedt@gmail.com">chuck.haatvedt@gmail.com</a></span></font></font></p>
    </div>
  </body>
</html>





^ permalink  raw  reply  [nested|flat] 2+ messages in thread

* Re: COBOL PRECOMPILER for PostGreSQL
@ 2024-01-13 06:08  Tom Lane <tgl@sss.pgh.pa.us>
  parent: Chuck Haatvedt <chuck.haatvedt@gmail.com>
  0 siblings, 0 replies; 2+ messages in thread

From: Tom Lane @ 2024-01-13 06:08 UTC (permalink / raw)
  To: Chuck Haatvedt <chuck.haatvedt@gmail.com>; +Cc: pgsql-general@postgresql.org, Simon Sobisch <simonsobisch@gnu.org>

Chuck Haatvedt <chuck.haatvedt@gmail.com> writes:
>       I would like to propose that the ECPG precompiler for C, to be
>       modified to accept either C or COBOL. Another option would be to
>       clone ECPG to work with the COBOL language.

The latter option seems much more likely to succeed than the former.

Either way, however, I'd guess that the amount of COBOL expertise
in the existing Postgres community is not distinguishable from zero.
So "proposing" this is not going to make it happen.  If you want to
step up with a patch, then maybe, but even then I'm not sure we'd
want to commit to maintaining it as part of the core PG project.
The most likely path to success is to plan on creating an ECPG
fork maintained separately by interested people.

FWIW, the only reason ECPG is part of our core distro is that
years ago it used to require significant manual effort to keep it
up to date with core grammar changes.  Since we invented a process
for auto-generating the ECPG grammar from the core grammar, it's
seemed like maybe ECPG could be kept at arm's length after all,
though we've not seriously tried to push it out as a separate
project.  We could talk about what additional stuff might be
needed in that infrastructure to make it work for a COBOL wrapper
... but I think somebody else has to take point on making that
happen.

			regards, tom lane





^ permalink  raw  reply  [nested|flat] 2+ messages in thread


end of thread, other threads:[~2024-01-13 06:08 UTC | newest]

Thread overview: 2+ messages (download: mbox mbox.gz follow: Atom feed)
-- links below jump to the message on this page --
2024-01-13 05:39 COBOL PRECOMPILER for PostGreSQL Chuck Haatvedt <chuck.haatvedt@gmail.com>
2024-01-13 06:08 ` Tom Lane <tgl@sss.pgh.pa.us>

This inbox is served by DDX for PostgreSQL; see mirroring instructions
for how to clone and mirror all data and code used for this inbox