ODBC Information
Additional information on ODBC may be found on CompuServe or via Internet as follows:
WINEXT
(Microsoft Windows Extensions)
INTERSOLV
(Creators of the Q+E ODBC Driver Kits)
Microsoft: http://www.microsoft.com/!ExecProgram("webdlt.exe http://www.microsoft.com/", 0)
Simba: http://www.pageahead.com/links.htm!ExecProgram("webdlt.exe http://www.pageahead.com/links.htm", 0)
Intersolv: http://www.intersolv.com/!ExecProgram("webdlt.exe http://www.intersolv.com/", 0)
ODBC SQL Reserved Words
The following words are reserved for use in ODBC function calls. To ensure compatibility with drivers that support the core SQL grammar, applications should avoid using any of these keywords.
ABSOLUTE |
ADA |
ADD |
ALL |
ALLOCATE |
ALTER |
AND |
ANY |
ARE |
AS |
ASC |
ASSERTION |
AT |
AUTHORIZATION |
AVG |
BEGIN |
BETWEEN |
BIT |
BIT_LENGTH |
BY |
CASCADE |
CASCADED |
CASE |
CAST |
CATALOG |
CHAR |
CHAR_LENGTH |
CHARACTER |
CHARACTER_LENGTH |
CHECK |
CLOSE |
COALESCE |
COBOL |
COLLATE |
COLLATION |
COLUMN |
COMMIT |
CONNECT |
CONNECTION |
CONSTRAINT |
CONSTRAINTS |
CONTINUE |
CONVERT |
CORRESPONDING |
COUNT |
CREATE |
CURRENT |
CURRENT_DATE |
CURRENT_TIME |
CURRENT_TIMESTAMP |
CURSOR |
DATE |
DAY |
DEALLOCATE |
DEC |
DECIMAL |
DECLARE |
DEFERRABLE |
DEFERRED |
DELETE |
DESC |
DESCRIBE |
DESCRIPTOR |
DIAGNOSTICS |
DICTIONARY |
DISCONNECT |
DISPLACEMENT |
DISTINCT |
DOMAIN |
DOUBLE |
DROP |
ELSE |
END |
END-EXEC |
ESCAPE |
EXCEPT |
EXCEPTION |
EXEC |
EXECUTE |
EXISTS |
EXTERNAL |
EXTRACT |
FALSE |
FETCH |
FIRST |
FLOAT |
FOR |
FOREIGN |
FORTRAN |
FOUND |
FROM |
FULL |
GET |
GLOBAL |
GO |
GOTO |
GRANT |
GROUP |
HAVING |
HOUR |
IDENTITY |
IGNORE |
IMMEDIATE |
IN |
INCLUDE |
INDEX |
INDICATOR |
INITIALLY |
INNER |
INPUT |
INSENSITIVE |
INSERT |
INTEGER |
INTERSECT |
INTERVAL |
INTO |
IS |
ISOLATION |
JOIN |
KEY |
LANGUAGE |
LAST |
LEFT |
LEVEL |
LIKE |
LOCAL |
LOWER |
MATCH |
MAX |
MIN |
MINUTE |
MODULE |
MONTH |
MUMPS |
NAMES |
NATIONAL |
NCHAR |
NEXT |
NONE |
NOT |
NULL |
NULLIF |
NUMERIC |
OCTET_LENGTH |
OF |
OFF |
ON |
ONLY |
OPEN |
OPTION |
OR |
ORDER |
OUTER |
OUTPUT |
OVERLAPS |
PARTIAL |
PASCAL |
PLI |
POSITION |
PRECISION |
PREPARE |
PRESERVE |
PRIMARY |
PRIOR |
PRIVILEGES |
PROCEDURE |
PUBLIC |
RESTRICT |
REVOKE |
RIGHT |
ROLLBACK |
ROWS |
SCHEMA |
SCROLL |
SECOND |
SECTION |
SELECT |
SEQUENCE |
SET |
SIZE |
SMALLINT |
SOME |
SQL |
SQLCA |
SQLCODE |
SQLERROR |
SQLSTATE |
SQLWARNING |
SUBSTRING |
SUM |
SYSTEM |
TABLE |
TEMPORARY |
THEN |
TIME |
TIMESTAMP |
TIMEZONE_HOUR |
TIMEZONE_MINUTE |
TO |
TRANSACTION |
TRANSLATE |
TRANSLATION |
TRUE |
UNION |
UNIQUE |
UNKNOWN |
UPDATE |
UPPER |
USAGE |
USER |
USING |
VALUE |
VALUES |
VARCHAR |
VARYING |
VIEW |
WHEN |
WHENEVER |
WHERE |
WITH |
WORK |
YEAR |
This is a list of some of the best known ODBC applications.
|
COMPANY |
PRODUCT |
COMPANY |
PRODUCT |
|
|
Andyne |
ANDYNE GQL |
Labtech |
Database Vision |
|
|
Applied Information Sciences (AIS) |
UniAccess Product Suite |
Logic Works |
ERwin/ERX v. 2.0 |
|
|
AutoDesk |
Autocad v. 12 |
Lotus |
Notes v3, DataLens, 1-2-3 for Windows v4.0, Lotus Approach |
|
|
BASIS International |
TAOS/Views, TAOS, BBx Profession/4 |
MapInfo |
MapInfo |
|
|
Blue Sky Software |
Visual SQL 2.0 |
MDBS |
MDBS 4, Object/1 |
|
|
Blyth Software |
Omnis 7 v2.1 |
Micro Design International |
XDE |
|
|
Born Software Development Group |
Outlook, Guide, ODBC for AS400 |
Microsoft |
Microsoft AccessÒ , Microsoft Excel, FoxProÒ , VC++, Visual Basic, Microsoft Word |
|
|
Brio |
DataPrism |
Must Software |
NOMAD 4GL, Front & Center |
|
|
Case Design |
Odyssee v. 3.5 Connectivity Addition |
N. Systems |
DBA Prep |
|
|
Chen & Associates |
Chen ER-Modeler Workbench |
NEOCOM Microspecialists |
Sentinel, Truck Driver Log |
|
|
Cognos |
Impromptu |
Neuron Data |
Smart Elements; C/S Elements |
|
|
Computer Associates |
CA-Realizer; CA-Visual Express, CA-Visual Objects |
PC Docs |
PC DOCS OPEN |
|
|
Computer Concepts |
DB Express |
Pilot Software |
LightShip Link v. 2.0 |
|
|
Confluence Technologies |
FundStation, PriceStation |
Platinum |
Platinum Publisher 4.1, Sequel Publisher v4.1 |
|
|
Coromandel |
Integra for Windowsä |
Powersoft |
PowerBuilder, PowerMaker, PowerViewer |
|
|
Crystal Services |
Crystal Reports v. 2.0 |
Praxis International |
Select v. 1.2 |
|
|
Cuebic Systems |
Cuebic v. 1.0 for Windows, Cuebic Exchange v. 2.0, Cuebic 4.3, Cuebic Financials v. 3.0 |
Progress Software |
Progress Provision |
|
|
DataEase |
DataEase Express for Windows 1.1 |
ProtoView Development |
SQL View 1.0 |
|
|
Delrina Technology, Inc |
Form-flow |
ReportSmith |
ReportSmith |
|
|
Easel Corporation |
Easel 4.0, Enfin 4.0 |
Revelation Technologies |
OpenInsight |
|
|
Fairfield Software |
Clear Access |
SAS Institute |
SAS v. 6.08m (16-bit), SAS v. 6.10 (Win32sä ) |
|
|
Felsina Software |
A-Talk for Windows |
Secure-Soft |
Dan-o Pump, PVCS meets Visual Basic |
|
|
Genus Software, Inc. |
MD Station, RN Station, RN Planner |
Software Publishing Corp. |
Superbase for Windows |
|
|
Great Plains Software |
Dynamics C/S+ |
Sonoran Technologies |
Tapestry |
|
|
Guild |
Guild |
SPSS |
SPSS 6.0 for Windows |
|
|
Gupta |
SQL Windows: Quest |
Step 2 Incorporated |
InfoPublisher |
|
|
Hyland Software |
OnBase |
The Dodge Group |
OpenSeries Financials |
|
|
KCI Computing |
Control |
Trinzic |
Forest and Trees v3.1 |
|
|
Keenan Systems |
Acumate |
Wang |
OPEN\query builder |
|
|
KnowledgeWare |
ObjectView 3.0; 2.1 now |
WordPerfect |
Informs 1.0a |
|