SQL Application Development in CA IDMS › SQL Application Development › Writing the Application

Writing the Application

Program Language

In the program language, you write everything that the application program requires except database access and the structures needed to handle database access. Embedding SQL in the program does not affect any rules that apply to using the program language.

Embedded SQL

Within the application program, you can embed SQL statements to:

• Access the database
• Access the dictionary
• Define the structures needed to transfer data between the program and the DBMS
• Manage SQL sessions and transactions

Note: For more information about the complete syntax for all CA IDMS SQL statements, see the CA IDMS SQL Reference Guide.