DataHub^™ ODBC Scripting

Prev		Next

DataHub^™ ODBC Scripting

Version 11.1

September 14, 2026

An implementation of the Gamma scripting language for use in Cogent DataHub^™ software that provides ODBC support.

Table of Contents

1. Introduction

1.1. Overview
1.2. Setting up a DSN (Data Source Name)
1.3. Working with MS Access

2. Tutorials

2.1. Tutorial 1: Writing new rows to a table, based on a trigger - Multi-Threaded Version
2.2. Tutorial 2: Writing new rows to a table, based on a trigger - Single-Threaded Version
2.3. Tutorial 3: Updating existing rows, or writing new ones
2.4. Tutorial 4: Writing data from a database to a DataHub instance
2.5. Viewing data from a web browser

3. An Explanation of the Tutorial Code

3.1. Define the Application Object

3.2. Interactions with the Database

3.2.1. Connecting to the Database
3.2.2. Creating a Gamma Class from a Database Table
3.2.3. Querying Rows from the Database
3.2.4. Inserting Rows into a Database
3.2.5. Updating Existing Rows in a Database
3.2.6. Creating a Database Table

3.3. Set up Event Handlers

3.4. Shut Down

4. Multi-Threaded ODBC Interface

4.1. How-To

4.1.1. Create an ODBCThread Instance
4.1.2. Attach Event Callbacks
4.1.3. Configure Startup Actions
4.1.4. Start the Database Thread

4.2. Store and Forward

4.2.1. Time Delayed Writes

4.3. Example

DATE_STRUCT — contains dates (y,m,d).
ODBCColumn —
ODBCConnection — allocates a connection handle.
ODBCDescriptor — allocates a descriptor handle.
ODBCEnvironment — allocates an environment handle.
ODBCHandle — a parent class for connections, descriptors, environments, and statements.
ODBCResult —
ODBCStatement — allocates a statement handle.
ODBCThread — configures the multi-threaded ODBC interface.
ODBCThreadResult — the results of an SQL command.
SQLGUID — holds ID strings.
SQL_DAY_SECOND_STRUCT — contains time data for SQL_INTERVAL_STRUCT.
SQL_INTERVAL_STRUCT — contains interval data for SQL queries.
SQL_INTERVAL_STRUCT_intval — contains year/month or day/second info for SQL_INTERVAL_STRUCT.
SQL_NUMERIC_STRUCT — specifies number precision and sign.
SQL_YEAR_MONTH_STRUCT — contains year and month data for SQL_INTERVAL_STRUCT.
TIMESTAMP_STRUCT — contains timestamp data (y,m,d,h,m,s, etc.).
TIME_STRUCT — contains time data (h,m,s).

6. Global Functions

ODBC_AllocEnvironment — creates an ODBCEnvironment.
ODBC_ValueString

7. Constants

Prev		Next
Appendix 2. License Copyright Information	Home	Chapter 1. Introduction