Examples for the sdb.sql Module

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