DataHub ODBC Scripting

Version 5.4

November 15, 2005

A user's guide to ODBC (Open DataBase Connectivity) scripting for the Cascade DataHub.

Copyright, trademark, and software license information.

Table of Contents


1. Introduction

2. Tutorials
2.1. Tutorial 1: odbcpets.g
2.2. Tutorial 2: odbcfoods.g

3. Classes
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.
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).

4. Global Functions
ODBC_AllocEnvironment - creates an ODBCEnvironment.
ODBC_ValueString -

5. Constants

Index