General programming

You can write programs that incorporate SQL statements and exchange data with the database server. That is, you can write a program to retrieve data from the database and format it however you choose. You can also write programs that take data from any source in any format, prepare it, and insert it into the database.

You can also write programs called stored routines to work with database data and objects. The stored routines that you write are stored directly in a database in tables. You can then execute a stored routine from DB-Access or an SQL Application Programming Interface (API) such as Informix® ESQL/C.

SQL programming, and Modify data through SQL programs, present an overview of how SQL is used in programs.