About this chapter

When you create scripts for a PowerBuilder application, you
can use embedded SQL statements in the script to perform operations
on the database. The features supported when you use embedded SQL
depend on the DBMS to which your application connects.

Overview

When you use the Informix IN9 database interface to connect
to a database, you can use embedded SQL in your scripts. You can
embed the following types of SQL statements in scripts and user-defined
functions:

• Transaction management statements

• Non-cursor statements

• Cursor statements

• Database stored procedures

Informix API

The Informix database interfaces use the Informix application programming
interface (API) to interact with the database.

When you use embedded SQL, PowerBuilder makes the required
calls to the API. Therefore, you do not need to know anything about
the Informix API in order to use embedded SQL in PowerBuilder.

See also

• Chapter 8, “Using Informix”

• Informix
  transaction management statements

• Informix non-cursor statements

• Informix cursor statements

• Informix database stored procedures

• Informix
  name qualification