Re: [Tiny-cobol-users] How to reduce the time for found a shared library ?

[Ferran P. F. <fer...@re...>]

On dv, 2002-08-23 at 15:19, Peter Burgess wrote:
> Hi=20
>=20
> Thanks for the information, what I would dont want to
> do is convert to the Eloquence db I want to go with an
> open source version, I was wondering what anyone else
> had used apart from the Postgresql mentioned below.
> This site was what interested me in the first place to
> using Tiny Cobol but does not have much in there yet !
>=20

There are 2 ways to use a free database with TC. The first is what you
have done with TC, use a wraper to access the C function calls of the C
API from cobol. This way you can use PostgreSQL or MySQL.

Another way is to use a SQL preprocesor. By now I think the only free
database  with a preprocesor for COBOL is firebird. I have tested it and
it works but still need some improvements, both the preprocesor and TC
to support the code generated by the preprocesor..

Can ge more info at http://www.firebird.org

Hope this helps :)

> Peter
>=20
>  --- Ferran Pegueroles Forcadell
> <fer...@re...> wrote: > On dv,
> 2002-08-23 at 10:23, Peter Burgess wrote:
> > > I am looking for some general librarys for
> > accessing
> > > databases using Tiny Cobol. Starting my first
> > hp3000
> > > conversion to Linux/Tiny Cobol , does anyone have
> > any
> > > resources they can point to that will work with an
> > sql
> > > db please.=20
> > >=20
> > Peter Osborn did a good job converting MPE/IX cobol
> > to Linux using
> > TinyCobol. They write this web to help people do the
> > same.
> >=20
> > http://linux.pwo.ca/
> >=20
> > This can help you as an start point. You can also
> > ask him for help.
> >=20
> > > Thanks for any help in advance.
> > >=20
> > > Regards
> > >=20
> > > Peter
> > >=20
> > >  --- Ferran Pegueroles
> > <fer...@re...>
> > > wrote: > eurlix wrote:
> > > >=20
> > > > >Hi All,
> > > > >
> > > > >I am trying to use postgreSQL with TC, using
> > > > Rildo's tdb02a.c
> > > > >compiled as a shared library.=20
> > > > >This works not too bad (thanks Rildo) but the
> > time
> > > > to start
> > > > >a program is almost TWENTY seconds.
> > > > >I think that is the time to find libpq.so in
> > > > /usr/lib/.
> > > > >I have tryed somethings like :
> > > > >- add "/usr/lib/libpq.so" in
> > TCOB_LD_LIBRARY_PATH,
> > > > >- recompile TC with libltdl,
> > > > >...
> > > > >but the time for start the program is always
> > the
> > > > same.
> > > > >
> > > > >As someone (perhaps Ferran) an idea about this
> > ?
> > > > >
> > > > >Regards,
> > > > > =20
> > > > >
> > > > Sorry for the late answer, I was on halydays.
> > > >=20
> > > > The calls to libpq are from the C source, then
> > the
> > > > TCOB_LD_LIBRARY_PATH=20
> > > > doesn't act on it. This only acts for finding
> > the
> > > > routines found on tdba.c
> > > >=20
> > > > My recomentation is, first link tdba.c with
> > libpq.
> > > > This can be done=20
> > > > easily because shared libs can be linked with
> > other
> > > > shared libs. This=20
> > > > should reduce the time needed to find libpq.=20
> > Then
> > > > the problem is the=20
> > > > time to fund the libraries found on tdb02a. A
> > good
> > > > solution is to rename=20
> > > > the shared object to something like libtdba.so.
> > > >=20
> > > > If this doesn't work try to inser displays and
> > > > printf on the cobol and c=20
> > > > source and see where is the time spend exactly.
> > > >=20
> > > > If nothing helps, ask me again with more
> > detailed
> > > > info.
> > > >=20
> > > > --=20
> > > > Salutacions / Regards
> > > >
> > >
> >
> +---------------------------------------------------------------+
> > > > | Ferran Pegueroles Forcadell                  =20
> >   =20
> > > >            |
> > > > | mailto:fer...@re...         =20
> >   =20
> > > >            |
> > > > | Tels (+34)937252106 - (+34)667658535         =20
> >   =20
> > > >            |
> > > > | C/Uni=F3 44 2n 2a 08201 Sabadell (BCN)         =20
> >   =20
> > > >            |
> > > >
> > >
> >
> +---------------------------------------------------------------+
> > > >=20
> > > >=20
> > > >=20
> > > >=20
> > > >
> > >
> >
> -------------------------------------------------------
> > > > This sf.net email is sponsored by: OSDN - Tired
> > of
> > > > that same old
> > > > cell phone?  Get a new here for FREE!
> > > >
> > >
> >
> https://www.inphonic.com/r.asp?r=3Dsourceforge1&refcode1=3Dvs3390
> > > > _______________________________________________
> > > > Tin...@li...
> > > >
> > >
> >
> https://lists.sourceforge.net/lists/listinfo/tiny-cobol-users
> >=20
> > >=20
> > > __________________________________________________
> > > Do You Yahoo!?
> > > Everything you'll ever need on one web page
> > > from News and Sport to Email and Music Charts
> > > http://uk.my.yahoo.com
> > >=20
> > >=20
> > >
> >
> -------------------------------------------------------
> > > This sf.net email is sponsored by: OSDN - Tired of
> > that same old
> > > cell phone?  Get a new here for FREE!
> > >
> >
> https://www.inphonic.com/r.asp?r=3Dsourceforge1&refcode1=3Dvs3390
> > > _______________________________________________
> > > Tin...@li...
> > >
> >
> https://lists.sourceforge.net/lists/listinfo/tiny-cobol-users
> >=20
> >=20
> >=20
> >
> -------------------------------------------------------
> > This sf.net email is sponsored by: OSDN - Tired of
> > that same old
> > cell phone?  Get a new here for FREE!
> >
> https://www.inphonic.com/r.asp?r=3Dsourceforge1&refcode1=3Dvs3390
> > _______________________________________________
> > Tin...@li...
> >
> https://lists.sourceforge.net/lists/listinfo/tiny-cobol-users=20
>=20
> __________________________________________________
> Do You Yahoo!?
> Everything you'll ever need on one web page
> from News and Sport to Email and Music Charts
> http://uk.my.yahoo.com