Writing application programs for SQL

Applications that interact with IMS must first connect to IMS. They can then read, add, or modify data or manipulate IMS databases.

Coding SQL statements in application programs: General information
IMS provides a way to issue SQL statements directly in a COBOL application to access your IMS data. IMS uses the same SQL coding techniques as Db2 for z/OS® when programming IMS SQL for COBOL.
Coding SQL statements in COBOL application programs
When you code SQL statements in COBOL application programs, you should follow certain guidelines.
Adding and modifying data
Your application program can query, modify, or delete data in any IMS segment for which you have the appropriate level of access.
Accessing data
Your program can read data from any IMS segments for which you have read access using SQL SELECT statements.
Commit or roll back data
After your application issues SQL statements to modify data in your IMS database, your application might want to commit or roll back database changes. To commit or roll back IMS database changes, use IMS DB system services DL/I calls.
Preparing an application to run on IMS
To prepare and run applications that contain SQL statements, you must coprocess, compile, and link-edit them.

Parent topic: Application programming for SQL