The examples show how you can execute SQL statements in SAP MaxDB databases using the sdb.sql module in a Python script.
Example: Establishing and Closing the Connection to a Database
Example: Executing an SQL Statement and Reading the Result Set
Example: Executing an SQL Statement and Navigating in the Result Set
Example: Executing an SQL Statement and Reading the Result Set with a For Loop
Example: Executing an SQL Statement and Querying Information About the Result Set
Example: Executing an SQL Statement Multiple Times with Different Values
Demo data |
Description |
---|---|
DBADMIN |
Database system administrator (as an example of a DBM operator) |
SECRET |
Password of the database system administrator |
DEMODB |
Demo database |