Using Embedded SQL with Informix
Contents
- Informix
name qualification - Informix
transaction management statements - Informix
using CONNECT, COMMIT, DISCONNECT, and ROLLBACK - Informix
performance and locking - Informix
non-cursor statements - Informix
DELETE, INSERT, and UPDATE - Informix
SELECT - Informix
cursor statements - Informix retrieval using
cursors - Informix
nonupdatable cursors - Informix updatable
cursors - Informix
FETCH statements - Informix FETCH NEXT
- Informix
FETCH FIRST, FETCH PRIOR, and FETCH LAST - Informix CLOSE for
cursors - Informix database stored
procedures - Informix retrieval using database
stored procedures - Informix
DECLARE and EXECUTE - Informix
FETCH - Informix
CLOSE - Informix
update using database stored procedures - Informix using database stored procedures in DataWindow
objects - Informix database stored procedure summary
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
Informix transaction management
statements
Informix non-cursor
statements