SQL statement usage with the IMS Universal JDBC driver
The following usage rules apply to SQL statements passed to IMS™ with the IMS Universal JDBC driver.
- Foreign key fields
In relational databases, hierarchies can be logically built by creating foreign key relationships between tables. In IMS, the hierarchies are explicit and are part of the database definition itself. The IMS Universal JDBC driver introduces the concept of foreign keys to capture these explicit hierarchies in a relational sense, which makes the SQL syntax for IMS equivalent to standard SQL. - SELECT statement usage
The SELECT statement is used to retrieve data from one or more tables. The result is returned in a tabular result set. - INSERT statement usage
The INSERT statement is used to insert new rows into a table. - UPDATE statement usage
The UPDATE statement is used to modify the data in a table. - DELETE statement usage
The DELETE statement is used to delete rows in a table. DELETE operations are cascaded to all child segments. - WHERE clause usage
In a SQL SELECT, UPDATE, and DELETE statement, the WHERE clause can be used to select data conditionally.