From: | "Emiliano Moscato" <moski666(at)gmail(dot)com> |
---|---|
To: | "Merlin Moncure" <mmoncure(at)gmail(dot)com> |
Cc: | "Martin Gainty" <mgainty(at)hotmail(dot)com>, pgsql-general(at)postgresql(dot)org |
Subject: | Re: Stored procedures in C |
Date: | 2008-04-24 16:56:27 |
Message-ID: | 4388f4180804240956r7f1813a8lccc3ca2589b22d45@mail.gmail.com |
Views: | Raw Message | Whole Thread | Download mbox | Resend email |
Thread: | |
Lists: | pgsql-general |
Guys, it has nothing to do with my question :D
I don't know why Martin answer to me anything about Cobol.
I just was looking how to query database in a stored procedure in C. Some
people pointed me to SPI documentation (at chapter 41 of oficial Postgres
documentation) that is being useful.
Thanks for worry about it :)
Emiliano
2008/4/24 Merlin Moncure <mmoncure(at)gmail(dot)com>:
> On Wed, Apr 23, 2008 at 6:38 PM, Martin Gainty <mgainty(at)hotmail(dot)com>
> wrote:
> >
> >
> > Emiliano and Mike
> >
> > The real challenge is trying to determine what a datatype is in
> cobol..for
> > that matter what is stack variable or heap in Cobol?
> > In the end you're better off <re>writing this mess (preferably in Java)..
> > unless of course you need the billable hours for
> > the first rewrite to C
> > then later rewrite to Java
>
> (have no idea how this relates to the OP's original question). If you
> are trying to port a cobol app to postgres, your best bet is to go
> through the client interface, libpq. If you had to do it on the
> server side, I would stick to cobol environments that are C ABI
> compatible. Writing general purpose data procedures in C is just not
> a very good idea most of the time...it's difficult and dangerous...C
> SPI has great uses, it's just not for everything.
>
> I personally think cobol is better suited for data processing type
> problems than java. Mapping cobol data types to SQL is not terribly
> difficult. cobol is notoriously difficult to port to another
> langauges...probably cheaper to connect it to the database via ISAM
> wrapper if the app is over a certain size. Many modern cobol
> environments support external data sources through various
> techniques...extfh for example. AcuCobol (crypticly) allows linking a
> ISAM emulation layer directly to the cobol runtime, one approach I've
> used in the past.
>
> merlin
>
--
mOsKi
"No hay nada que uno haga mal , lo que hay es poco vino." Autor Anonimo
From | Date | Subject | |
---|---|---|---|
Next Message | Tom Lane | 2008-04-24 16:57:43 | Re: [GENERAL] I think this is a BUG? |
Previous Message | Brendan Jurd | 2008-04-24 16:47:39 | Re: [GENERAL] I think this is a BUG? |