Call-Level Interface

Call-level interface is used to embed SQL code in a host program, such as ANSI C. Application programmers should be very familiar with the concept of call-level interface. It is one of the methods that allows a programmer to embed SQL in different procedural programming languages. When using call-level interface (CLI), you simply pass the text of an 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 an 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