Cross platform
compatibility on Windows and Unix,
Multi-user on all
versions,
Client-Server
option,
Row level locking,
Efficient cost-based
optimizer -- no need to be an expert to code efficient SQL,
Transaction support
(COMMIT, ROLLBACK), with automatic rollback in case of software or hardware
failure,
Security (GRANT, REVOKE),
Math functions, aggregate
functions (COUNT, SUM, ...),
Views,
Subqueries (ex: SELECT
... WHERE colx in (SELECT ... ) )
Table aliasing (ex:
SELECT ... FROM part a, part b WHERE a.part_no = b.is_part_of)
Cursors, with update
(UPDATE ... WHERE CURRENT OF ...)
Standard SQL variable
length strings (VARCHAR) and native C character strings (ASCIZ),
Unlimited table size,
Multi-column indexes
(up to 128 columns, in any order),
No limit on the number
of indexes,
Complete interactive
command line SQL utility program with source code,
Table unload/reload,
to ASCII files, already in SQL; can be used within your programs or with
interactive SQL,
... and low code memory
requirement - won't turn your application into "bloatware":
email: sales@justlogic.com
Last modification: 10/96