SQL programming reference
These topics provide the reference information for Structured Query Language (SQL) for IMS™.
SQL concepts for IMS
Certain IMS concepts are important to understand when using Structured Query Language (SQL).- Language elements
An understanding of the basic syntax of SQL and language elements that are common to many SQL statements can be helpful in using SQL with IMS. - SQL statements
This section contains syntax diagrams, semantic descriptions, rules, and examples of the use of the SQL statements. - SQL communication area (SQLIMSCA)
An SQLIMSCA is a structure or collection of variables that is updated after each SQL statement executes. An application program that contains executable SQL statements must provide exactly one SQLIMSCA. - SQL descriptor area (SQLIMSDA)
An SQLIMSDA is a collection of variables that is required for execution of the SQLIMS DESCRIBE statement, and can be optionally used by the FETCH statements. An SQLIMSDA can be used in a DESCRIBE statement, modified with the addresses of host variables, and then reused in a FETCH statement.