Table of 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
