Programming language-specific interfaces that allow you to incorporate SQL statements in a program are available, thus allowing you to access a database from a program. SESAM/SQL provides an interface for the programming language COBOL.
The concepts involved in embedding SQL statements in a program are the same for all programming languages and are referred to as ESQL (Embedded SQL). Programs that include embedded SQL statements are called ESQL programs.
This chapter explains the concepts involved in embedding SQL statements in a program. It covers the following topics:
Program structure
Host variables
Monitoring success and error handling
cursor
Dynamic SQL
You will find language-specific details in the “ ESQL-COBOL for SESAM/SQL-Server” manual.