Using Embedded SQL with Microsoft SQL Server
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 your PowerBuilder application connects to a SQL Server
database, you can use embedded SQL in your scripts. This interface
uses the DB-Library (DB-Lib) client API to access the database.
When you use the SQL Server database interface, 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
DB-Library API
The Microsoft SQL Server database interface uses the DB-Library
(DB-Lib) application programming interface (API) to access the database. When
you use embedded SQL, PowerBuilder makes the required calls to the
API. Therefore, you do not need to know anything about DB-Lib to use
embedded SQL in PowerBuilder.