Introduction to AcuSQL

Welcome to the AcuSQL® pre-compiler and runtime library. This add-on tool to the ACUCOBOL-GT® development system is a simple, cost-effective solution for those who want or need to use embedded SQL (ESQL) statements in COBOL programs to access SQL-conversant data sources.

AcuSQL is part of the extend® family of technologies and is designed to give COBOL applications access to IBM® DB2®, Microsoft® SQL Server, and ISO/ANSI SQL92 compliant data sources. AcuSQL also supports the open source database, MySQL®.

Unless otherwise indicated, the references to Windows in this help denote the following versions of the Windows operating systems: Windows XP, Windows Vista, Windows 7, Windows 2003, Windows 2007, Windows 2008 R2. Where necessary, individual versions of those operating systems are referred to by their specific version numbers (WindowsXP, Windows Vista, etc.). AcuSQL is available for most UNIX® operating system platforms, including 64-bit environments.

The AcuSQL pre-compiler is a powerful programming tool that allows you to embed SQL statements in your COBOL application. ESQL enables you to access the power and flexibility of Structured Query Language (SQL) from within your COBOL application. With AcuSQL, you can execute complex data selection and processing operations using the database engine to perform most of the work, greatly simplifying the COBOL code needed to perform the operation. AcuSQL supports both static and dynamic SQL.

AcuSQL support of native dialects of SQL (DB2, MySQL, SQL Server), ISO/ANSI SQL92, and a relaxed version of SQL enables you to write applications custom-tailored to a wide variety of individual databases or a more generic version able to run across multiple databases and data sources.

AcuSQL support for ESQL is provided by a special pre-compiler and runtime library.