Sybase SQL Parser for Java and .NET

Sybase SQL that GSP parses

CREATE PROCEDURE update_dept_count @dept INT AS
BEGIN
  UPDATE dept SET cnt = (SELECT COUNT(*) FROM emp WHERE emp.dept_id = @dept)
  WHERE dept.id = @dept
END

Parse it in Java

import gudusoft.gsqlparser.*;

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

• Stored procedures (T-SQL)
• Watcom IF...THEN...END IF
• WRITETEXT and INSERT BULK
• DUMP TRANSACTION
• ON COMMIT ROWS
• Procedural SQL: Transact-SQL stored procedures and functions with exception handlers, including Sybase IQ procedure bodies and Watcom IF...THEN...END IF

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

Planning a Sybase modernization project? See how to build a Sybase T-SQL migration inventory in Java or .NET without treating the parser as an end-to-end code converter.

Recent Sybase parser updates

• 2026-07-06 [Sybase] Support empty statements and ON COMMIT ROWS
• 2026-05-29 [Sybase] Support Watcom IF ... THEN ... END IF in procedure bodies
• 2026-05-19 [Sybase] Hook EXCEPTION clause into TBlockSqlNode + TMssqlBlock

Full history in the release notes.