INXSQL, The SQL database interface of Open Abal, has been adapted to offer database access via ODBC .

The ODBCversion of Open Abal has been tested with the following database engines:

1. SQL SERVER 18 on UBUNTU
2. SQL SERVER 18 on RED HAT
3. SQL SERVER 18 on AMAZON RDS

The ODBCversion of Open Abal is currently available for the following operating systems:

1. Ubuntu 20.04
2. Red Hat Enterprise Linux 9.3

This version of Open Abal is currently available for down load from the AMENESIK Open Abal depot.

The start of the year 2024 has seen a huge evolution concerning Open Abal.

1. Open Abal is now available for the following operating systems and open-source database engines:
   • Ubuntu 20.04
     • MySQL
     • MariaDB
     • PostgreSQL
   • Red Hat Enterprise Linux RHEL 9.3
     • MySQL
     • MariaDB
     • PostgreSQL

    

   These versions are all available for deployment in the cloud using the Amenesik Enterprise Cloud.

   ---

    

2. A new feature has been added to the Open Abal language allowing the declaration of SQL COLUMNS ( OPEN ABAL KEYS ) and SQL INDEXES (OPEN ABAL LINKS ) on the PRIMARY INDEX of SQL TABLES ( OPEN ABAL MULTIPLE INDEX SEQUENTIAL INDEX FILES ).

   The full collection of KEY types are available for definition of KEY/LINKS on the PRIMARY INDEX.

   • KA : declares a traditional BINARY string COLUMN/KEY.
   • KB : declares a traditional BCD (binary coded decimal) NUMERIC COLUMN/KEY.
   • KD : declares a numeric Y% M# D# formatted DATE COLUMN/KEY.
   • KF : declares a four byte FLOAT or 8 byte DOUBLE COLUMN/KEY.
   • KH : declares a 64 bit integer COLUMN/KEY.
   • KL : declares a 32 bit integer COLUMN/KEY.
   • KS : declares a UTF8 string COLUMN/KEY.
   • KT : declares a numeric H# M# S# formatted TIME COLUMN/KEY.

A presentation of Open Abal was held on the 9th October 2023, in Conegliano, Treviso, Italia.

For all of those of you that were present at this meeting, and have received your connection details:

• the link to the test server can be found here: Conegliano Open Abal
• the link to the Open Abal Wiki can be found here : Open Abal Wiki

The following documents, relating to the Linux Version of Open Abal, are now available for download

• Open Abal Lanugage Reference 5.1a
• Open Abal Visual Library Version 5.1a
• Open Abal Getting Started
• Open Abal SV RT SI MC

The Open Abal Visual Library has been ported and qualified for use with ABAL applications on UBUNTU and REDHAT operating systems.

The documentation of the library has been completely rewritten providing precise details of all function call options.

The new version of ABAL, known as Open Abal has been extended by the addition of a PARQUET reader and writer library.This allows a direct connection between Open Abal applications and third party Big Data processing systems and platforms.

The PARQUET Writer section of the library offers the following functions:

1. Parquet Create File
2. Parquet Create Column
3. Parquet Write Row
4. Parquet Flush

The PARQUET Reader section of the library offers the following functions:

1. Parquet Open File
2. Parquet Get Column Count
3. Parquet Get Row Count
4. Parquet Read Row
5. Parquet Close

The PARQUET Writer and Reader functions can handle the following encodings

• PLAIN
• DICTIONARY
• RLE Hybrid

and can handle fragmented files stored across multiple file locations.

The new version of ABAL,  known as Open Abal, allows your ABAL Applications to be accessed through any of the modern day, commercial web browsers:

1. Chrome
2. Edge
3. Firefox
4. Safari
5. Opera

Subsequently, your ABAL applications can be accessed, by users, from anywhere in the world.

The new version of ABAL,  known as Open Abal, will allow your ABAL Applications to be used from any of the standard, commercial, modern platforms:

1. Windows PC
2. Apple Mac
3. Android Pad and Phone
4. Apple iPhone and iPad

Subsequently, your ABAL applications will no longer be restricted to use from the limited range of proprietary thin clients.

The new version of ABAL,  known as Open Abal, will allow your ABAL Applications to store their data on the standard, commercial, modern SQL Database Systems:

1. MySQL 8
2. PostgreSQL 12

Subsequently, your ABAL applications will no longer be confined to the previous legacy database system of CRITERIA.

The new version of ABAL, known as Open Abal, will allow the deployment of your ABAL Applications on the following standard, commercial, modern 64 bit LINUX based systems:

1. UBUNTU 20.04
2. RED HAT FEDORA

Subsequently, your ABAL applications will no longer be confined to the previous legacy systems of USEIT.