GixSQL User Manual
Embedded SQL for GnuCOBOL — SuperBOL edition
superbol,gixsql,gnucobol,cobol,sql,esql
This manual is available:
Generated on 2026-11-18 from commit superbol-manuals@a5e6f46
Preface
This manual describes GixSQL, an embedded SQL (ESQL) precompiler and runtime library for GnuCOBOL. It covers the SuperBOL edition of GixSQL, maintained at https://github.com/superbol4gnucobol/gixsql-superbol, which continues the original work of Marco Ridoni (https://github.com/mridoni/gixsql).
Who should read this manual
This manual is for COBOL programmers who write programs that embed SQL statements (EXEC SQL ... END-EXEC), and for people who port programs written for other precompilers, in particular Oracle Pro*COBOL, to GnuCOBOL. Some knowledge of COBOL and SQL is assumed.
How this manual is organized
The organization follows that of most ESQL precompiler manuals, so that readers who know Pro*COBOL can find their way:
- Getting started: what GixSQL is, how to install it, and how to precompile, compile and run a first program.
- Programming with embedded SQL: connections and transactions, host variables and datatypes, the SQL statements, error handling and dynamic SQL.
- Reference: the options of the
gixppprecompiler, the runtime configuration, and a guide to migrate Pro*COBOL programs. - Database backends: the notes for each database driver.
- Appendices: a summary of the embedded SQL statements, and the error codes.
Conventions
gixppoptions are written as--long-option(with their short form-xwhen there is one).- Environment variables are written in capitals:
GIXSQL_LOG_LEVEL. - COBOL examples use the fixed source format: the code starts at column 8.