Using Embedded SQL with SAP Adaptive Server Enterprise
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