Introduction

SQL stands for Structured Query Language. As the industry standard database access language, SQL is widely used in developing software applications with database management requirements.

RaimaDB 16.0 provides a subset of the ANSI/ISO standard SQL ("RaimaDB SQL") that is suitable for running on a wide variety of computers and operating systems. RaimaDB SQL is designed specifically for embedded systems applications, where DBMS capability requirements are not as broad as those for enterprise systems. Some non-standard features designed specifically for the needs of embedded computing applications are also included.

Common features of SQL that are not implemented in RaimaDB SQL include:

• Database views (CREATE VIEW)

• Security privileges (GRANT and REVOKE)

• CHECK clause integrity constraints

• SELECT UNION

Non-standard features that have been added to RaimaDB SQL based on embedded application requirements include the ability to:

• Include compiled C modules containing statically initialized database catalog tables

• Create user-defined SQL functions in C

• Limit the number of rows in a result set from a SELECT statement by number or time

This manual uses standard database and SQL terminology. If there is a term that is unclear, refer to the glossary toward the end of the manual for a definition.