Using Embedded SQL with OLE DB
Contents
- OLE DB
SQL support - OLE DB Name
qualification - OLE DB SQL
functions - OLE DB
Using ODBC escape Sequences - OLE DB
Transaction management statements - OLE DB Using
CONNECT, DISCONNECT, COMMIT, and ROLLBACK - OLE DB
Performance and locking - OLE DB
Non-cursor statements - OLE DB DELETE, INSERT, and UPDATE
- OLE DB
SELECT - OLE DB
Cursor statements - OLE DB
Retrieval using cursors - OLE DB
FETCH NEXT - OLE DB
Database stored procedures - OLE DB
Retrieval - OLE DB
DECLARE and EXECUTE - OLE DB
FETCH - OLE DB
CLOSE - OLE DB
EXECUTE - OLE DB Using
database stored procedures in DataWindow objects
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 PowerBuilder OLE DB interface to connect to a backend
database, you can use embedded SQL in your scripts.
You can embed the following types of SQL statements in scripts and
user-defined functions if the OLE DB driver you are using and the backend
DBMS you are accessing supports this functionality. (Not all backend
databases support cursor statements and database stored procedures.)
-
Transaction management statements
-
Non-cursor statements
-
Cursor statements
-
Database stored procedures
OLE DB Programming Models
OLE DB is a set of COM (Component Object Model) interfaces that
provide uniform access to data stored in multiple, diverse data sources.
These data sources also enable applications to provide additional database
services.
When you use embedded SQL, PowerBuilder makes the required calls to
the backend database. Therefore, you do not need to know anything about the
OLE DB interface to use embedded SQL with PowerBuilder.
See also