IBM Netezza SQL Syntax Support¶
This page documents the SQL syntax support for IBM Netezza in the General SQL Parser.
Syntax Coverage Corpus¶
GSP tests Netezza syntax against 73 documented constructs grouped into 25 categories, each cross-referenced to the specific page in Netezza's own documentation that defines it (73 distinct source pages).
Parse coverage¶
Measured on 2026-07-25 against GSP Java 4.1.5.15, the current release. Each construct carries the complete set of examples from Netezza's documentation; a construct counts as fully covered only when every one of its examples parses.
| Constructs | Individual statements | |
|---|---|---|
| Fully parsed | 65 of 73 (89%) | 149 of 169 (88%) |
Statements are split using the parser's own statement splitter, so multi-statement examples and procedure bodies are counted correctly.
Categories covered¶
| Category | Constructs |
|---|---|
| CREATE | 11 |
| SHOW | 11 |
| ALTER | 10 |
| DROP | 10 |
| SET | 10 |
| GENERATE | 2 |
| BEGIN | 1 |
| COMMENT | 1 |
| COMMIT | 1 |
| COPY | 1 |
| DELETE | 1 |
| EXPLAIN | 1 |
| GRANT | 1 |
| GROOM | 1 |
| INSERT | 1 |
| LOCK | 1 |
| MERGE | 1 |
| REINDEX | 1 |
| RESET | 1 |
| REVOKE | 1 |
| ROLLBACK | 1 |
| SELECT | 1 |
| TRUNCATE | 1 |
| UPDATE | 1 |
| WITH | 1 |
Full construct lists are being published progressively; see Sybase, PostgreSQL or MySQL.
Key Features Supported¶
- Standard SQL operations (SELECT, INSERT, UPDATE, DELETE)
- Netezza-specific functions and data types
- Stored procedures and user-defined functions
- Window functions and analytical queries
- Distribution and zone map optimizations
- External table operations