Hello Joe!
SQL and gnuCobol ?
Not a problem, I run ACAS all in Cobol and uses GC (gnuCobol) compiler that
uses Mysql (Or Mariadb) with no problems what so ever. Other run :
Oracle, DB/2, Postgres, SQLlite, DMS etc.
Just a case of finding the pre compiler and running against GC having made
any needed changes for X64 etc.
Note that Open Cobol was renamed gnuCobol some years ago when taken in to
and under the GNU banner.
> To be honest, I've glanced at the manuals and the things I could find
> but am not convinced those issues have been sufficiently addressed yet
> - or I've missed things.
Should also have looked at the FAQ on SF for the needed topics to find out
how and of course the various forums again on SF.
> I've been in the IBM Cobol system since whenever, using al databases
> they've ever used, using CICS command level up to the current sysplex
> solutions. Even created interactive CLIST/REXX bussiness applications
> in places where CICS was not used ;-)
KICS is not in the eco system yet, mostly because the only one I know of is
still under closed beta testing although there might well be others out
there.
> Maybe I'm spoiled but to survive in the current flood of new
> languages, frameworks, whatever, thorough reliable database interfaces
> to MySQL, MariaDB, Postgress, forms of MQTT 3 and 5 including quality
> level 2 are needed. As I'm not a language developer and retirement is
> getting closer, I now want faster results (not to be seen as instant
> gratification....) instead of having to find separate components and
> or C/Java interfaces.
> It's not a rant - I sincerely hope Cobol gets back on the agenda as it
> is a fantastic language. I just don't think were there yet - and IBM
> will not support a flagship product for broad and (almost) free
> use.....
As I said these components are available and usable. I have run a small
variant of ACAS using DB/2, Oracle and some others (but not SQLlite - no
point) but mostly for testing if they worked under Linux X64.
I did not continue with these despite saying in the ACAS docs that others
(other than MySQL/Mariadb) was possible subject to requests - there has not
been any, so have to assume any one interested has done it themselves as
the controlling Cobol modules for dealing as a DAL was already written.
All Cobol programs and modules that required access to Cobol Files / SQL
tables called a FH (File Handler) for each file which in turn if tables
are in use would call the specific DAL (Data Access Layer) that would
access the correct table.
A bit long winded in initial development but makes it easy for using other
RDBMS systems.
Vincent