search

mridoni / gixsql

GixSQL is an ESQL preprocessor and a series of runtime libraries to enable GnuCOBOL to access PostgreSQL, ODBC, MySQL, Oracle and SQLite databases.
GNU General Public License v3.0
16 stars 8 forks source link

Support for `DISCONNECT ALL` #89

Closed GitMensch closed 2 years ago

GitMensch commented 2 years ago

Just dropping it here as it came up with ESQL once and while I personally don't need it currently it would be a good thing to have implemented and added to the testsuite: DISCONNECT ALL.

Would it be handled in the driver (= all open connections stored, then closed at once) or by the underlying library?

           EXEC SQL
               DISCONNECT ALL
           END-EXEC.

unsupported SQL: DISCONNECT ALL

IBM docs Oracle docs

Originally posted by @GitMensch in https://github.com/mridoni/gixsql/issues/72#issuecomment-1179534596

mridoni commented 2 years ago

Implemented in the internal repository, will be in v1.0.17. Fixed a few memory leaks along the way.

GitMensch commented 2 years ago

According to the release notes: solved.