SQL Parser

The generic SQL parser accepts the following dialects of the SQL language:

A separate SQL parser is available for TANDEM NonStop SQL.

The parsers build an abstract syntax tree that stores and represents the source program in memory. Optionally name analysis can be performed. The parsers can operate stand alone or they can be attached to the parsers for COBOL, PL/I and C in order to analyze embedded statements enclosed in EXEC SQL directives.

The generic SQL parser accepts plain SQL source code, only. CoCoLab provides auxiliary programs that extract embedded SQL from COBOL, PL/I, C source code and from shell scripts. The extracted SQL code can be processed by the generic SQL parser.

Notes

IBM DB2

The generic parser accepts all DML, DDL, and SDL statements of IBM Universal Database versions 4, 7 and 8 including PL/SQL. The following DB2 control commands are implemented: CATALOG, CREATE DATABASE, EXPORT, IMPORT, LOAD, REORG, RUNSTATS, UNCATALOG, UNLOAD, UPDATE.

Oracle and Informix

The SQL parser accepts all DML (Data Manipulation Language) statements and most DDL (Data Definition Language) statements. Oracle PL/SQL is supported.

Sybase

The SQL parser accepts all constructs from Sybase Adaptive Server Anywhere, version 6 with a few exceptions:

The following interactive GUI commands are not implemented: CLEAR, CONFIGURE, EXIT, Help, SYSTEM. The following commands are not implemented, because no precise syntax definition could be found in the manual: PARAMETERS, READ, READTEXT, WRITETEXT. The following command is not implemented, because it allows arbitrary C code: WHENEVER ... { C-code }.

Microsoft

The SQL parser accepts all DML (Data Manipulation Language) statements and all control flow statements.

References

IBM DB2

Oracle

Sybase

Informix

Microsoft



About Us
Overview
History
Team
Products
Applications
Parsers
Cocktail Toolbox
Services
Development
Maintenance
Training
Downloads
Demo Software
Documentation
Updates
Cocktail
Information
News
Partner
Contact

Deutsch