GixSQL User Manual

Embedded SQL for GnuCOBOL — SuperBOL edition

Author

The SuperBOL Team at Titagone-OCamlPro

Published

November 12, 2026

Keywords

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 gixpp precompiler, 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

  • gixpp options are written as --long-option (with their short form -x when 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.