Sams Teach Yourself SQL in 24 Hours, Third Edition By Ronald R. Plew, Ryan K. Stephens
Table of Contents
Hour 22. Advanced SQL Topics
A call-level interface (CLI) is used to embed SQL code in a host program, such as ANSI C. Application programmers should be very familiar with the concept of a call-level interface. It is one of the methods that allows a programmer to embed SQL in different procedural programming languages. When using a call-level interface, you simply pass the text of a SQL statement into a variable using the rules of the host programming language. You can execute the SQL statement in the host program through the use of the variable into which you passed the SQL text.
EXEC SQL is a common host programming language command that allows you to call a SQL statement (CLI) from within the program.
EXEC SQL
The following are examples of programming languages that support CLI:
COBOL
ANSI C
Pascal
FORTRAN
Ada
Refer to the syntax of the host programming language with which you are using call-level interface options.