Re: Stored procedures in C

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