HP 3000 Manuals HP 3000 Manuals
Chapter 6 SQL Differences Between ALLBASE/SQL and SQLBase
ALLBASE/SQL and SQLBase differ somewhat, and you need to be aware of the
differences when you are coding SQL to access ALLBASE/SQL databases.
SQLWindows and other Gupta products are designed to access the SQLBase
DBMS, so the Gupta documentation defines SQL as it is used by SQLBase.
You also need to be aware of the differences if you are porting an
application which was designed to access SQLBase to access ALLBASE/SQL.
This chapter explains which SQL syntax to use within the application
software to access ALLBASE/SQL databases. Some logical constructs and
SQL syntax are handled differently by ALLBASE/SQL and SQLBase. The
following topics are discussed:
* Mapped constructs: a description of the minor differences that
are resolved automatically by PC API.
* Unsupported SQL syntax and logical constructs: a description of
differences that may require programmer modification.