Sybase IQ SQL Parser for Java

Sybase IQ SQL that GSP parses

CREATE HG INDEX ix_prod ON order_items (product_id)

Parse it in Java

import gudusoft.gsqlparser.*;

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

• IQ specialized indexes: HG, LF, HNG, WD, DATE/TIME
• CREATE JOIN INDEX and SYNCHRONIZE JOIN INDEX
• IQ UTILITIES and dbspace management (CREATE/ALTER DBSPACE)
• LOAD TABLE bulk loading
• BACKUP, RESTORE, and CHECKPOINT
• Procedural SQL: Watcom-SQL and T-SQL procedure, function, and event definitions, with CALL, cursor blocks, and SIGNAL/RESIGNAL handlers

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

Recent Sybase IQ parser updates

• 2026-08-17 [Sybase IQ] Dedicated IQ vendor with its own grammar, statement splitter, and syntax coverage page
• 2026-08-17 [Sybase IQ] Reject ASE-only statements such as DUMP TRANSACTION, READTEXT, and UPDATE INDEX STATISTICS, naming the product each belongs to
• 2026-08-16 [Sybase] Keep the trailing parameter mode OUTPUT/OUT

Full history in the release notes.