ODBC for RTXHDB

Real Time eXecutives, Inc.

ODBC for RTXHDB


The ODBC for RTXHDB is a Microsoft Windows 32-Bit ODBC driver that allows SQL queries of the RTXHDB database. Over the last few years, SQL has become the standard computer database language. Where RTXHDB is the ideal type of database for storing process data, other types of data are more suited for relational or other databases. The RTXHDB historical database software allows these different kinds of data to be accessed and used simultaneously. With the ODBC for RTXHDB, ODBC compliant applications can retrieve data from RTXHDB for use in other applications. ODBC for RTXHDB conforms to Microsoft's Open Database Connectivity (ODBC) standard, a SQL-based facility. Open Database Connectivity (ODBC) is the name given to a set of standards that allow a client application to access data in any database without having to write vendor-specific code. Instead, the client application sends queries to a standard interface called an ODBC Driver. Most personal computer applications that can use RDBMS data can work with ODBC for RTXHDB. Examples of ODBC client applications include Microsoft Query, Q+E for Microsoft Excel, Microsoft Access, Microsoft Visual Basic and Powersoft's PowerBuilder. ODBC for RTXHDB is very useful for applications that combine RTXHDB data with data from other sources, e.g., laboratory data, maintenance data, and cost accounting.


FEATURES


TYPICAL KEYWORDS

SELECT DATE IS OR >
ALL DISTINCT LIKE SUM <
AND FROM MAX TIME =
AVG GROUP MIN TIMESTAMP >=
BY HAVING NOT WHERE <=
COUNT IN NULL *  

EXAMPLES

1) SELECT DATE, TIME, FLOW1, FLOW2
FROM HOUR
WHERE DATE = `11/14/1995'
2) SELECT DATE, TIME, FLOW1, FLOW2
FROM HOUR
WHERE FLOW2 <= 3030
AND DATE = `14-NOV-95'
3) SELECT DATE, TIME, FLOW1, FLOW2,FLOW3
FROM HOUR
WHERE FLOW2 <= 3030
AND FLOW3 > FLOW1
AND DATE = `Nov 14 1995'
4) SELECT AVG (FLOW1), MIN(FLOW1)
FROM HOUR
WHERE FLOW2 <= 3030
AND DATE = `November 14, 1995'
5) SELECT *
FROM SHIFT
WHERE DATE >= `11-15-95'
6) SELECT DATE, TIME, (.3*PRESS3)
FROM DAY
WHERE DATE <= `1995 NOV 16'
7) SELECT *, (FLOW2 - FLOW3)
FROM HOUR
WHERE DATE <= `11/16/1995'
AND TIME >= `10:00:00'
8) SELECT DATE, TIME, PRESS2
FROM MINUTE
WHERE DATE >= `11/16/1995'
AND TIME = `10:00:00 PM'
9) SELECT DATE, TIME, LEVEL1, FLOW1
FROM MINUTE
WHERE DATE = `11/16/1995'
AND TIME >= `10:00:00' AND TIME <= `11:00:00'
10) SELECT *
FROM HOUR_def

Note: Format for references to DATE, TIME, TIMESTAMP may be application specific.

Specifications

Requirements:

Recommended:

  • Windows 98 / Me / NT 4.0 / 2000 / XP Pro
  • Microsoft Excel 97 (Version 8.0) or Microsoft Excel 2000 (Version 9.0)
  • Microsoft Access 97 / 2000
  • Windows 2000 / XP Pro
  • Microsoft Excel 2000 (Version 9.0)
  • Microsoft Access 97 / 2000

RTX Home Page Back Home
Products and Services Products
and Services
RTXHDB User Applications Back to RTXHDB
User Applications
Real Time eXecutives, Inc. 1996 - 2008
Page constructed by
RTX Web Services