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@gmail.com>:
On Wed, Apr 23, 2008 at 6:38 PM, Martin Gainty <
mgainty@hotmail.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
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
