Sybase ASE SQL Parser for Java

Sybase ASE 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.dbvsybasease);
parser.sqltext = sql; // the Sybase ASE SQL above
if (parser.parse() == 0) {
    System.out.println(parser.sqlstatements.size() + " statement(s) parsed");
} else {
    System.out.println(parser.getErrormessage());
}

Java edition only. The .NET library has no Sybase ASE grammar, so this dialect cannot be parsed from C# or VB.NET. See the .NET SQL Parser SDK for the dialects it does cover.

What GSP handles in Sybase ASE

• T-SQL procedures, triggers, and CREATE OR REPLACE PROCEDURE
• DUMP TRANSACTION, DBCC, and UPDATE/DELETE STATISTICS
• CREATE EXISTING TABLE (Component Integration Services)
• Global variables (@@identity) and COMPUTE clauses
• SET IDENTITY_INSERT, SETUSER, LOCK TABLE
• Procedural SQL: Transact-SQL stored procedures, triggers, and user-defined functions, including CREATE OR REPLACE PROCEDURE and DECLARE CURSOR blocks

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

Recent Sybase ASE parser updates

• 2026-08-17 [Sybase ASE] Dedicated ASE vendor with its own grammar, statement splitter, and syntax coverage page
• 2026-08-17 [Sybase ASE] Reject Watcom-SQL procedure syntax that belongs to SQL Anywhere
• 2026-08-17 [Sybase ASE] Reject Sybase IQ specialized index types and IQ-only DDL

Full history in the release notes.