Using Embedded SQL with Microsoft SQL Server
Contents
- Microsoft
SQL Server Name qualification - Microsoft
SQL Server Functions - Microsoft
SQL Server Transaction management statements - Microsoft
SQL Server Using CONNECT, COMMIT, DISCONNECT, and ROLLBACK - Microsoft
SQL Server Using AutoCommit - Microsoft
SQL Server Performance and locking - Microsoft
SQL Server Non-cursor statements - Microsoft
SQL Server DELETE, INSERT, and UPDATE - Microsoft
SQL Server SELECT - Microsoft
SQL Server Cursor statements - Microsoft
SQL Server Fetching rows - Microsoft
SQL Server FETCH NEXT - Microsoft
SQL Server FETCH FIRST, FETCH PRIOR, and FETCH LAST - Microsoft
SQL Server Closing the cursor - Microsoft SQL Server Database stored procedures
- Microsoft
SQL Server Retrieval - Microsoft
SQL Server DECLARE and EXECUTE - Microsoft
SQL Server FETCH - Microsoft
SQL Server CLOSE - Microsoft
SQL Server Update - Microsoft
SQL Server Temporary tables - Microsoft
SQL Server Using database stored procedures in DataWindow
objects - Microsoft
SQL Server Database stored procedures 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 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.
See also
Microsoft SQL Server
Functions
Microsoft SQL Server
Transaction management statements
Microsoft SQL Server
Non-cursor statements
Microsoft SQL Server Cursor
statements
Microsoft SQL Server Using
database stored procedures in DataWindow objects