I don't have time at the moment to give this the thought it deserves, but I
very much welcome this.
Jon
On 12 February 2010 18:57, David Ashley <[email protected]> wrote:
> I gave the issue of multiple CLI library access more thought and I think
> I have a rather elegant solution to allow this. I still need to do some
> experimental coding and testing but this might be possible. I will give
> it a try this weekend and see if I can make it work. Keep your fingers
> crossed.
>
> David Ashley
>
> On 02/12/2010 12:16 PM, Bill Turner, WB4ALM wrote:
> > David, is your proposed syntax flexible enough to allow the possibility
> > of multiple CLI libraries at a ("much") later time?
> > Having thought about it now would minimize having to make major changes
> > that might impact "first release" code later on.
> >
> > I am very much interested in the possibility of "built-in" SQL support...
> > ...and from what I have heard from other developers, this would be a
> > very welcomed addition.
> > For me, it would also simplify installation issues.
> >
> >
> > /s/ Bill Turner, wb4alm
> >
> >
> >
> >
> > David Ashley wrote:
> >
> >> This design would allow access to one (and only one) CLI library during
> >> the execution of the program. But, this could be any vendor's CLI
> >> library. Access to multiple CLI libraries within a single process is
> >> MUCH harder and I am not willing to tackle it at this time.
> >>
> >> David Ashley
> >>
> >> On 02/12/2010 10:05 AM, John Bodoh wrote:
> >>
> >>
> >>> David,
> >>>
> >>> Will your design allow access to different CLI libraries within the
> same
> >>> REXX?
> >>>
> >>> John
> >>>
> >>> -----Original Message-----
> >>> From: David Ashley [mailto:[email protected]]
> >>> Sent: Friday, February 12, 2010 10:35 AM
> >>> To: ooRexxDevel
> >>> Subject: [Oorexx-devel] ooRexx SQL Project
> >>>
> >>> All -
> >>>
> >>> I have started thinking about creating an SQL library for ooRexx. My
> >>> plans at the moment look like this:
> >>>
> >>> 1. Use the ISO 92 specification with the Microsoft ODBC v3 extensions
> >>> (also know as the CLI interface) as the portable API code in the
> >>> library. All the major database vendors support these APIs and it is OS
> >>> and platform independent.
> >>> 2. I will create an oo-centric set of classes and methods to
> encapsulate
> >>> the API. Two major classes will cover almost everything: database and
> >>> statement classes. There will be a few minor classes but most of the
> >>> interface will be in these two classes.
> >>>
> >>> There is one major difference between my design and the RexxSQL
> function
> >>> library design. The RexxSQL design statically links to the database
> >>> vendor's CLI library. Thus you need a different RexxSQL library for
> >>> every vendor's library. I will use a dynamically linked solution where
> >>> the vendor's library is loaded at run time rather than loaded at
> program
> >>> initialization (or RexxSQL library initialization). Thus the user can
> >>> specify at run time the vendor library they want to link to i.e. DB2,
> >>> ODBC, Oracle, etc.
> >>>
> >>> The big advantage to this design is that it will be independent of any
> >>> vendor's library. Thus the ooRexx library can access any vendor's
> >>> library. Only one version of the library is needed for all database
> >>> vendors. That also means the library can be distributed with easily.
> >>>
> >>> That is as far as my thinking has taken me so far. I would like to get
> >>> opinions and other thoughts from everyone who care to comment on this
> as
> >>> I believe this will become a high profile extension to ooRexx and I
> want
> >>> to get it right.
> >>>
> >>> Thanks,
> >>> David Ashley
> >>>
> >>>
> ----------------------------------------------------------------------------
> >>> --
> >>> SOLARIS 10 is the OS for Data Centers - provides features such as
> DTrace,
> >>> Predictive Self Healing and Award Winning ZFS. Get Solaris 10 NOW
> >>> http://p.sf.net/sfu/solaris-dev2dev
> >>> _______________________________________________
> >>> Oorexx-devel mailing list
> >>> [email protected]
> >>> https://lists.sourceforge.net/lists/listinfo/oorexx-devel
> >>>
> >>>
> >>>
> ------------------------------------------------------------------------------
> >>> SOLARIS 10 is the OS for Data Centers - provides features such as
> DTrace,
> >>> Predictive Self Healing and Award Winning ZFS. Get Solaris 10 NOW
> >>> http://p.sf.net/sfu/solaris-dev2dev
> >>> _______________________________________________
> >>> Oorexx-devel mailing list
> >>> [email protected]
> >>> https://lists.sourceforge.net/lists/listinfo/oorexx-devel
> >>>
> >>>
> >>>
> >>>
> >>
> >>
> ------------------------------------------------------------------------------
> >> SOLARIS 10 is the OS for Data Centers - provides features such as
> DTrace,
> >> Predictive Self Healing and Award Winning ZFS. Get Solaris 10 NOW
> >> http://p.sf.net/sfu/solaris-dev2dev
> >> _______________________________________________
> >> Oorexx-devel mailing list
> >> [email protected]
> >> https://lists.sourceforge.net/lists/listinfo/oorexx-devel
> >>
> >>
> >>
> >
> >
> ------------------------------------------------------------------------------
> > SOLARIS 10 is the OS for Data Centers - provides features such as DTrace,
> > Predictive Self Healing and Award Winning ZFS. Get Solaris 10 NOW
> > http://p.sf.net/sfu/solaris-dev2dev
> > _______________________________________________
> > Oorexx-devel mailing list
> > [email protected]
> > https://lists.sourceforge.net/lists/listinfo/oorexx-devel
> >
> >
>
>
>
> ------------------------------------------------------------------------------
> SOLARIS 10 is the OS for Data Centers - provides features such as DTrace,
> Predictive Self Healing and Award Winning ZFS. Get Solaris 10 NOW
> http://p.sf.net/sfu/solaris-dev2dev
> _______________________________________________
> Oorexx-devel mailing list
> [email protected]
> https://lists.sourceforge.net/lists/listinfo/oorexx-devel
>
------------------------------------------------------------------------------
SOLARIS 10 is the OS for Data Centers - provides features such as DTrace,
Predictive Self Healing and Award Winning ZFS. Get Solaris 10 NOW
http://p.sf.net/sfu/solaris-dev2dev
_______________________________________________
Oorexx-devel mailing list
[email protected]
https://lists.sourceforge.net/lists/listinfo/oorexx-devel
