Re: [open-cobol-list] Postgres

[Gerald Chudyk]

COBOL can create a comma separated list of field values, with tags
if necessary.  These can in turn be fed to an SQL program as
updates to fields. I did something like this many moons ago with C
as the intermediary and a mini-sql system invented by Mary Bochane
called MDBMS.

Or you might use the postgresql api for c and write cobol calls to
this same api. My blunt and short lived effort showed a 1:1 conversion
of c calls to cobol calls. My decision was to talk directly from
OpenCOBOL to the postresql api and avoid writing/using any middleware.
Of course the project was shelved until further notice, so there may
be some gottcha's that I have yet to find.

Gerald




On 8/10/09, John Culleton <address@hidden> wrote:
> On Sunday 09 August 2009 10:33:02 pm emre wrote:
>> emre wrote:
>> > John Culleton wrote:
>> >> In your applications, what does Postgres do for you that
>> >> Indexed sequential with multiple keys won't?  Ad Hoc reporting
>> >> is an advantage but if that is the application I would use the
>> >> SQL based database stand-alone without COBOL.
>> >
>> > You are correct, I don't really _need_ to go to an SQL. What I
>> > am really looking
>> > for is an easy way to get ODBC. Thinking about this further,
>> > the extra SQL layer
>> > will probably slow things down unacceptably.
>>
>> So what I really want to do is to be able to periodically
>> synchronize some fields in
>> one COBOL table with an SQL table. I could probably do this
>> externally in perl
>> or else use something like libdbi to do it in COBOL. Then, I can
>> use an SQL (such as
>> postgres or mySQL) which has an existing ODBC server.
>>
>> Emre.
>
> COBOL can create a comma separated list of field values, with tags
> if necessary.  These can in turn be fed to an SQL program as
> updates to fields. I did something like this many moons ago with C
> as the intermediary and a mini-sql system invented by Mary Bochane
> called MDBMS.
>
> --
> John Culleton
> Create Book Covers with Scribus/e-book $5.95
> http://www.booklocker.com/books/4055.html
>
> ------------------------------------------------------------------------------
> Let Crystal Reports handle the reporting - Free Crystal Reports 2008 30-Day
> trial. Simplify your report design, integration and deployment - and focus
> on
> what you do best, core application coding. Discover what's new with
> Crystal Reports now.  http://p.sf.net/sfu/bobj-july
> _______________________________________________
> open-cobol-list mailing list
> address@hidden
> https://lists.sourceforge.net/lists/listinfo/open-cobol-list
>