 |
Real Time eXecutives, Inc.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 ODBC for RTXHDB Architecture |
 |
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: |
|
|
|
|
|
|
