The examples show how you can execute SQL commands in a MaxDB database instance with the sdb.sql module.
● Connecting/Closing the Connection to the Database Instance
● Executing an SQL Statement and Reading the Result Set
● Executing SQL Statements and Navigating in the Result Set
● Executing an SQL Statement and Reading the Result Set with a For Loop
● Executing SQL Statements and Querying Information About the Result Set
● Executing an SQL Statement Multiple Times with Different Values
● Executing SQL Statements and Handling Errors
The examples use the following demo data:
Demo Data |
Description |
DBADMIN |
Database system administrator (SYSDBA user) as an example of a DBM operator |
SECRET |
Password of the database system administrator |
DEMODB |
Demo database |