IBM Netezza SQL Parser Support in GSP¶
Explore the IBM Netezza SQL Parser product page
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 5 categories, each cross-referenced to the documentation that defines it (73 distinct source pages).
Parse coverage¶
Measured against GSP Java 4.2.8 on 2026-08-31 (UTC) (artifact sha256 1117856ef134). Each construct below carries the complete set of examples from the Netezza documentation; a construct counts as fully covered only when every one of its examples parses. Percentages are pass rates over this documented-example corpus — not a percentage of the entire SQL dialect.
| Constructs fully parsed | Individual statements parsed | |
|---|---|---|
| All constructs | 65 of 73 (89%) | 149 of 169 (88%) |
| SELECT (queries) | 6 of 6 (100%) | 13 of 13 (100%) |
| DML (INSERT / UPDATE / DELETE / MERGE) | 5 of 6 (83%) | 14 of 16 (88%) |
| Stored procedures | — | — |
Statements are split using the parser's own statement splitter, so multi-statement examples and procedure bodies are counted correctly. The SELECT, DML and stored-procedure rows classify each statement by its parsed statement type: a construct is counted in a row when its examples contain at least one statement of that class, and is fully parsed when all of them parse. Stored procedures covers CREATE PROCEDURE / FUNCTION / PACKAGE / TRIGGER definitions and anonymous blocks.
Machine-readable: dialect data (JSON) · all-dialect matrix · coverage matrix overview
All 73 constructs¶
| Construct | Category | Parses | Specified in |
|---|---|---|---|
BEGIN |
all 1 | IBM docs | |
COMMENT ON |
4 of 5 | IBM docs | |
COMMIT |
all 5 | IBM docs | |
COPY |
all 2 | IBM docs | |
DELETE |
all 4 | IBM docs | |
EXPLAIN |
all 4 | IBM docs | |
GENERATE EXPRESS STATISTICS |
all 1 | IBM docs | |
GENERATE STATISTICS |
all 2 | IBM docs | |
GRANT |
all 1 | IBM docs | |
GROOM TABLE |
all 4 | IBM docs | |
INSERT |
all 4 | IBM docs | |
LOCK TABLE |
all 1 | IBM docs | |
MERGE |
4 of 6 | IBM docs | |
REINDEX DATABASE |
0 of 1 | IBM docs | |
RESET |
all 2 | IBM docs | |
REVOKE |
all 1 | IBM docs | |
ROLLBACK |
all 1 | IBM docs | |
SELECT (to retrieve rows) |
6 of 7 | IBM docs | |
SET |
all 6 | IBM docs | |
SET TRANSACTION |
all 1 | IBM docs | |
SHOW |
all 1 | IBM docs | |
SHOW AUTHENTICATION |
all 3 | IBM docs | |
SHOW CONNECTION |
all 1 | IBM docs | |
SHOW HISTORY CONFIGURATION |
all 1 | IBM docs | |
SHOW PLANFILE |
all 1 | IBM docs | |
SHOW SCHEDULER RULE |
all 3 | IBM docs | |
SHOW SCHEMA |
all 2 | IBM docs | |
SHOW SESSION |
all 3 | IBM docs | |
SHOW SYSTEM DEFAULT |
all 1 | IBM docs | |
SHOW TAGS |
all 1 | IBM docs | |
SHOW TEMP TABLE |
all 2 | IBM docs | |
TRUNCATE |
all 1 | IBM docs | |
UPDATE |
all 2 | IBM docs | |
WITH clause |
all 3 | IBM docs | |
ALTER DATABASE |
ALTER | all 1 | IBM docs |
ALTER GROUP |
ALTER | all 5 | IBM docs |
ALTER HISTORY CONFIGURATION |
ALTER | all 1 | IBM docs |
ALTER SCHEDULER RULE |
ALTER | 0 of 2 | IBM docs |
ALTER SEQUENCE |
ALTER | all 1 | IBM docs |
ALTER SESSION |
ALTER | 0 of 3 | IBM docs |
ALTER SYNONYM |
ALTER | all 2 | IBM docs |
ALTER TABLE |
ALTER | all 8 | IBM docs |
ALTER USER |
ALTER | all 4 | IBM docs |
ALTER VIEW and ALTER VIEWS ON |
ALTER | all 2 | IBM docs |
CREATE DATABASE |
CREATE | all 1 | IBM docs |
CREATE GROUP |
CREATE | all 5 | IBM docs |
CREATE HISTORY CONFIGURATION |
CREATE | all 4 | IBM docs |
CREATE MATERIALIZED VIEW |
CREATE | all 1 | IBM docs |
CREATE SCHEDULER RULE |
CREATE | 0 of 9 | IBM docs |
CREATE SEQUENCE |
CREATE | all 1 | IBM docs |
CREATE SYNONYM |
CREATE | all 1 | IBM docs |
CREATE TABLE |
CREATE | all 5 | IBM docs |
CREATE TABLE AS |
CREATE | all 2 | IBM docs |
CREATE USER |
CREATE | all 3 | IBM docs |
CREATE VIEW |
CREATE | all 3 | IBM docs |
DROP DATABASE |
DROP | all 1 | IBM docs |
DROP GROUP |
DROP | all 1 | IBM docs |
DROP HISTORY CONFIGURATION |
DROP | all 1 | IBM docs |
DROP SCHEDULER RULE |
DROP | 0 of 1 | IBM docs |
DROP SEQUENCE |
DROP | all 1 | IBM docs |
DROP SESSION |
DROP | all 1 | IBM docs |
DROP SYNONYM |
DROP | all 1 | IBM docs |
DROP TABLE |
DROP | all 1 | IBM docs |
DROP USER |
DROP | all 1 | IBM docs |
DROP VIEW |
DROP | all 1 | IBM docs |
SET AUTHENTICATION |
SET | all 4 | IBM docs |
SET CATALOG |
SET | all 1 | IBM docs |
SET CONNECTION |
SET | all 1 | IBM docs |
SET HISTORY CONFIGURATION |
SET | all 1 | IBM docs |
SET SCHEDULER RULE |
SET | all 1 | IBM docs |
SET SCHEMA |
SET | all 1 | IBM docs |
SET SESSION |
SET | all 1 | IBM docs |
SET SYSTEM DEFAULT |
SET | all 1 | IBM docs |
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