Using Embedded SQL

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
DBHandle
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
JDBC DECLARE and EXECUTE
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
ADO.NET DECLARE and EXECUTE
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