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.
CREATE statement usage
The CREATE statement is used to create a resource in IMS.
ALTER statement usage
The ALTER statement is used to modify a resource in IMS.
DROP statement usage
The DROP statement is used to remove a resource in IMS.
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.
HEX and binary literals usage
An application developer can use standard SQL to specify HEX and binary literal values in SQL statements for SELECT, INSERT, UPDATE and DELETE queries.
WHERE clause usage
In a SQL SELECT, UPDATE, and DELETE statement, the WHERE clause can be used to select data conditionally.

Parent topic: Writing SQL queries to access an IMS database with the IMS Universal JDBC driver