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.

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

Microsoft SQL Server Name qualification