SQL Standards

SQL Standards

These days a lot of emphasis is placed on SQL syntax standards. The problem is that the standardization stops with the easiest part — the SQL syntax.

Every database server uses different communication mechanisms, embedded SQL, return codes, library calls, and data retrieval techniques. Some provide dynamic SQL mechanisms, allowing your application to build the SQL dynamically (i.e. OpenBase and Sybase), while others require a precompiler that converts the static SQL in your applications to some other form. Every server has slight differences, so the fact that they support the ANSI standard syntax, for instance, does not automatically make your application portable to other systems.

Please note that while OpenBase supports standard SQL, we have taken the liberty to deviate from the standards in order to more closely match the needs of customers.

Unless otherwise stated, the content of this page is licensed under Creative Commons Attribution-ShareAlike 3.0 License