This part describes how to use embedded SQL when accessing a database with that interface in a PowerBuilder application.
Table of Contents
- Using Embedded SQL with ODBC
-
- ODBC SQL Support
- ODBC Name qualification
- ODBC SQL functions
- ODBC Using escape clauses
- ODBC Transaction management statements
- ODBC Using CONNECT, DISCONNECT, COMMIT, and ROLLBACK
- ODBC Performance and locking
- ODBC Non-cursor statements
- ODBC DELETE, INSERT, and UPDATE
- ODBC SELECT
- ODBC Cursor statements
- ODBC Retrieval using cursors
- ODBC FETCH NEXT
- ODBC FETCH FIRST, FETCH PRIOR, and FETCH LAST
- ODBC Update
- ODBC Database stored procedures
- ODBC Retrieval
- ODBC DECLARE and EXECUTE
- ODBC DECLARE and EXECUTE with PBNewSPInvocation
- ODBC FETCH
- ODBC CLOSE
- ODBC EXECUTE
- ODBC Using database stored procedures in DataWindow objects
- Using Embedded SQL with JDBC
- Using Embedded SQL with OLE DB
-
- OLE DB SQL support
- OLE DB Name qualification
- OLE DB SQL functions
- OLE DB Using ODBC escape Sequences
- OLE DB Transaction management statements
- OLE DB Using CONNECT, DISCONNECT, COMMIT, and ROLLBACK
- OLE DB Performance and locking
- OLE DB Non-cursor statements
- OLE DB DELETE, INSERT, and UPDATE
- OLE DB SELECT
- OLE DB Cursor statements
- OLE DB Retrieval using cursors
- OLE DB FETCH NEXT
- OLE DB Database stored procedures
- OLE DB Retrieval
- OLE DB DECLARE and EXECUTE
- OLE DB FETCH
- OLE DB CLOSE
- OLE DB EXECUTE
- OLE DB Using database stored procedures in DataWindow objects
- Using Embedded SQL with ADO.NET
- Using Embedded SQL with SAP Adaptive Server Enterprise
-
- 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
- Using Embedded SQL with Informix
-
- Informix name qualification
- Informix transaction management statements
- Informix using CONNECT, COMMIT, DISCONNECT, and ROLLBACK
- Informix performance and locking
- Informix non-cursor statements
- Informix DELETE, INSERT, and UPDATE
- Informix SELECT
- Informix cursor statements
- Informix retrieval using cursors
- Informix nonupdatable cursors
- Informix updatable cursors
- Informix FETCH statements
- Informix FETCH NEXT
- Informix FETCH FIRST, FETCH PRIOR, and FETCH LAST
- Informix CLOSE for cursors
- Informix database stored procedures
- Informix retrieval using database stored procedures
- Informix DECLARE and EXECUTE
- Informix FETCH
- Informix CLOSE
- Informix update using database stored procedures
- Informix using database stored procedures in DataWindow objects
- Informix database stored procedure summary
- Using Embedded SQL with Microsoft SQL Server
-
- 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
- Using Embedded SQL with Oracle
-
- Oracle Name qualification
- Oracle SQL functions
- Oracle Transaction management statements
- Oracle Using CONNECT, DISCONNECT, COMMIT, and ROLLBACK
- Oracle Performance and locking
- Oracle Non-cursor statements
- Oracle DELETE, INSERT, and UPDATE
- Oracle SELECT
- Oracle Cursor statements
- Oracle Retrieval
- Oracle Update
- Oracle Cursor support summary
- Oracle Database stored procedures
- Supported features when using Oracle stored procedures
- Using DECLARE, EXECUTE, FETCH, and CLOSE with Oracle stored procedures
- Oracle DECLARE and EXECUTE
- Oracle FETCH
- Oracle CLOSE
