Jacob:
SQL does indeed contain FOR, WHILE, and generic LOOP constructs. It also includes PREPARE, DECLARE cursor, EXECUTE, FETCH, CLOSE, etc. It is even delivered with the Compatibility bladelet that includes file IO functions that you can install. So, yes, not as powerful as Oracle's PL/SQL, but pretty good now.
As for what will be in OneDB v3.0.0.1, it has not been definitively announced yet and so not set in stone. At this point it is expected to be minor things like the better support for Kubernetes and other Cloud packaging as Brian spoke about, support for the latest .NET protocol and other APIs.
------------------------------
Art S. Kagel, President and Principal Consultant
ASK Database Management Corp.
www.askdbmgt.com------------------------------
Original Message:
Sent: Fri August 25, 2023 01:46 PM
From: Jacob Salomon
Subject: Paul's presentation on One-DB
Great presentation there, Paul. Of course you only barely scratched the surface. Will the slides be made available for downloading? Also, I don't recall seeing any slides related to features on One-DB missing in IDS, planned or already in place. What kind of superset would it be without additional features.
Here's one feature I have not seen in IDS: A scripting language to match Oracle's (hiss! boo! ;-) PL/SQL, with looping and calling constructs. SPL just doesn't cut it because it must be compiled into the database. Or does it already exist but I've been away too long?
| The first lesson of economics is scarcity: there is never enough of |
| anything to fully satisfy all those who want it. The first lesson of |
| politics is to disregard the first lesson of economics. |
+--------------- Thomas Sowell (Is Reality Optional?::Student Loans) --+