Table of Contents
- SAP Adaptive Server Enterprise Name qualification
- SAP Adaptive Server Enterprise SQL functions
- SAP Adaptive Server Enterprise Transaction management statements
- SAP Adaptive Server Enterprise Using CONNECT, COMMIT, DISCONNECT, and ROLLBACK
- SAP Adaptive Server Enterprise Using AutoCommit
- SAP Adaptive Server Enterprise Performance and locking
- SAP Adaptive Server Enterprise Non-cursor statements
- SAP Adaptive Server Enterprise DELETE, INSERT, and UPDATE
- SAP Adaptive Server Enterprise SELECT
- SAP Adaptive Server Enterprise Cursor statements
- SAP Adaptive Server Enterprise Retrieval Using Cursors
- SAP Adaptive Server Enterprise Closing the Cursor
- SAP Adaptive Server Enterprise Database stored procedures
- SAP Adaptive Server Enterprise Retrieval
- SAP Adaptive Server Enterprise DECLARE and EXECUTE
- SAP Adaptive Server Enterprise FETCH
- SAP Adaptive Server Enterprise CLOSE
- SAP Adaptive Server Enterprise Update
- SAP Adaptive Server Enterprise Return values and output parameters
- SAP Adaptive Server Enterprise Temporary tables
- SAP Adaptive Server Enterprise System stored procedures
- SAP Adaptive Server Enterprise 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 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
