IBM Informix SQL Parser for Java and .NET

IBM Informix SQL that GSP parses

CREATE PROCEDURE raise_pay(emp_id INT, pct DECIMAL(5,2))
  UPDATE employee SET salary = salary * (1 + pct / 100)
  WHERE id = emp_id;
END PROCEDURE;

Parse it in Java

import gudusoft.gsqlparser.*;

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

• SPL procedures and functions
• CREATE ROW TYPE
• Collection queries
• EXECUTE IMMEDIATE
• ALTER FRAGMENT
• Procedural SQL: SPL stored procedures, functions, and triggers, including EXECUTE PROCEDURE/FUNCTION and EXECUTE IMMEDIATE

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

Recent IBM Informix parser updates

• 2026-06-02 [Informix] Carry column list on table-level PRIMARY KEY
• 2026-01-11 Delegate Impala and Informix parsing to VendorParsers
• 2025-10-07 Migrate Informix to modular architecture

Full history in the release notes.