Introduction to Physical Design › SQL and Non-SQL Definitions

SQL and Non-SQL Definitions

In CA IDMS, you have the choice of implementing your database design with either SQL or non-SQL definition statements. The choice of which definition language to use is based on the specific needs of your application.

Most of the physical design process is the same, regardless of which language is chosen. In those few areas of design implementation where the options differ for SQL and non-SQL, those options are clearly noted in this manual.

Likewise, there are some variances in the terminology used with each of the implementation languages. The accompanying table outlines sets of equivalent terminology.

Table of Terms