Using Embedded SQL with SAP Adaptive Server Enterprise

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 SAP Adaptive Server Enterprise interface, 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

Client Library API

The SAP Adaptive Server Enterprise database interface uses the Client Library (CT-Lib) 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 CT-Lib to use embedded SQL in PowerBuilder.

See also

Using Adaptive Server Enterprise

SAP Adaptive Server Enterprise SQL functions

SAP Adaptive Server Enterprise Transaction management statements

SAP Adaptive Server Enterprise Non-cursor statements

SAP Adaptive Server Enterprise Cursor statements

SAP Adaptive Server Enterprise Database stored procedures

SAP Adaptive Server Enterprise Name qualification