SQL reference

The SQL reference information includes general information about SQL language elements, security, views, and SQL information about specific data sources.

General information
You can use the following language elements and syntax diagrams for any of the supported database management systems.
IMS
You can use the CREATE TABLE, ALTER TABLE and CREATE INDEX statements to define tables and indexes that reference IMS databases.
VSAM
You can use the CREATE TABLE and ALTER TABLE statements to define tables that reference VSAM files. You can use the CREATE INDEX statement to define indexes that reference VSAM files.
SQL security
Security of your data is particularly important in an SQL-based DBMS, because interactive SQL makes database access very easy. The security requirements of production databases can include data in any given table that is accessible to some users, but denied to others, and allow some users to update data in a table, while others can only view data.
Views
In Classic federation, views can provide alternative ways to work with the data.
Restrictions on binary data in SQL operations
When you reference binary data in SQL operations, some restrictions apply to binary data.

Parent topic: Reference