AcuSQL

AcuSQL

Embedded SQL. It’s ingrained in your COBOL programs. It’s what binds your legacy applications to your relational data. It gives your users precise access to the information they need to do their jobs. AcuSQL

is an embedded SQL precompiler designed for businesses like yours. It scans your COBOL source file for SQL statements and translates them into COBOL CALL statements that the ACUCOBOL-GT compiler can process. At runtime, a powerful SQL runtime library provides seamless access to your data. Product OverviewAcuSQL is a simple, cost-effective solution for those who use embedded SQL statements in their COBOL programs to access SQL-con-versant data sources. AcuSQL is a Structured Query Language (SQL) precompiler that sup-ports the inclusion of embedded SQL (ESQL) statements in ACUCOBOL-GT program source code. The AcuSQL precompiler, in combination with an AcuSQL runtime library, allows your ESQL COBOL programs to access in ISO/ANSI SQL92-compliant data sources such as MySQL, Microsoft SQL Server and IBM DB2. AcuSQL supports both static and dynamic SQL so you can control the queries sent to the data-base as much as required.Key BenefitsLeverage the power and flexibility of SQL from COBOLSimplify the COBOL code needed to perform data operationsExecute complex data operations that utilize the capabilities of the database engineWrite applications tailored to a wide variety of individual databasesDevelop and deploy on Windows, UNIX and/or Linux (choice of server is database-dependent)Key FeaturesAcuSQL is a simple, cost-effective solution for IT organizations which want to use embedded SQL statements in their COBOL programs to access SQL-conversant data sources.Access to Multiple DatabasesAcuSQL gives your end users access to ISO/ANSI SQL92-conversant data sources. It is cer-tified by Micro Focus® to work with Microsoft SQL Server, IBM DB2 and MySQL.Flexibility in Source File FormatThe precompiler can read and parse source code files in two common formats: Terminal and ANSI. You can also pre-compile “mixed-mode” files that contain both terminal and ANSI source formats. This flexibility enables you to use existing files regardless of format. AcuSQL even processes ESQL statements within COPY files.Data SheetAcuSQLProduct Specifications and System Requirements COBOL applications can be run on any of the following hosts:• UNIX, Linux, Windows XP, Windows Vista, Windows 7, Windows 8, Windows 10, Windows Server 2003, Windows Server 2008, Windows Server 2012Data sources can be hosted on one (or more) of the following environments:• UNIX, Linux, Windows XP, Windows Vista, Windows 7, Windows 8, Windows 10, Windows Server 2003, Windows Server 2008, Windows Server 2012, OS390 (DB2 only)