Entering content frame

This graphic is explained in the accompanying text Examples for the sdb.sql Module Locate the document in the library structure

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

 

 

Leaving content frame