IBM Netezza SQL Parser for Java and .NET

IBM Netezza SQL that GSP parses

GROOM TABLE sales RECORDS ALL;
GENERATE STATISTICS ON sales;

Need us to check your own IBM Netezza SQL? Send a sample.

Parse it in Java

import gudusoft.gsqlparser.*;

TGSqlParser parser = new TGSqlParser(EDbVendor.dbvnetezza);
parser.sqltext = sql; // the IBM Netezza SQL above
if (parser.parse() == 0) {
    System.out.println(parser.sqlstatements.size() + " statement(s) parsed");
} else {
    System.out.println(parser.getErrormessage());
}

Parse it in C#

using gudusoft.gsqlparser;

TGSqlParser parser = new TGSqlParser(EDbVendor.dbvnetezza);
parser.sqltext = sql; // the IBM Netezza SQL above
if (parser.parse() == 0)
{
    Console.WriteLine(parser.sqlstatements.size() + " statement(s) parsed");
}
else
{
    Console.WriteLine(parser.Errormessage);
}

Same grammar, .NET-idiomatic API — properties instead of Java getters. See the C# quick start or the .NET SQL Parser SDK.

What GSP handles in IBM Netezza

• GROOM TABLE
• GENERATE STATISTICS
• External tables
• CALL/EXECUTE PROCEDURE
• LIMIT with offset
• Procedural SQL: NZPLSQL stored procedures, including CREATE PROCEDURE and CALL/EXECUTE PROCEDURE invocation

Beyond parsing, the same AST powers table/column extraction, validation, formatting, and column-level lineage for IBM Netezza.

Recent IBM Netezza parser updates

• 2026-03-15 [Netezza] Fix AexprConst precedence and trim whitespace
• 2026-02-17 Add Netezza TIMESTAMP(date, time) function support
• 2026-01-16 Add Netezza CALL/EXECUTE PROCEDURE syntax support

Full history in the release notes.