IBM Db2 SQL Parser for Java and .NET

IBM Db2 SQL that GSP parses

CREATE PROCEDURE update_salary(IN p_id INT)
BEGIN
  DECLARE v_count INT DEFAULT 0;
  UPDATE staff SET salary = salary * 1.05 WHERE id = p_id;
END

Parse it in Java

import gudusoft.gsqlparser.*;

TGSqlParser parser = new TGSqlParser(EDbVendor.dbvdb2);
parser.sqltext = sql; // the IBM Db2 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.dbvdb2);
parser.sqltext = sql; // the IBM Db2 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 Db2

• SQL PL compound statements
• Condition handlers
• Cursor declarations
• FETCH FIRST n ROWS
• IMPLICITLY HIDDEN columns
• Procedural SQL: SQL PL procedures, functions, and triggers with cursors, condition handlers, and dynamic compound statements

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

Recent IBM Db2 parser updates

• 2026-06-02 [DB2] Surface stored-procedure CALL in dlineage call graph
• 2026-06-02 [DB2] Populate FETCH FIRST n count on TFetchFirstClause
• 2026-04-18 [DB2] Support IMPLICITLY HIDDEN column attribute

Full history in the release notes.