Using Embedded SQL
This part describes how to use embedded SQL when accessing a
database with that interface in a PowerBuilder application.
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
- ODBC SQL
- 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
- OLE DB
- 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
- SAP Adaptive
- 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
- Informix
- 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
- Microsoft
- 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
- Oracle Name
Document get from Powerbuilder help
Thank you for watching.
Subscribe
Login
0 Comments
Oldest