InstantSQL™

Business Challenge

Today’s business climate includes a renewed focus on driving down costs within the IT organization. When multiple technologies are used to address a common business need there are unnecessary costs introduced into the management of those systems, building connections between them, and dealing with multiple vendors. A common area in which this is seen is data access. InstantSQL provides a simplified way of using popular, relational databases directly from within your RM/COBOL application.

Product Overview

InstantSQL provides a simplified but high performance way of using popular relational databases directly from within your RM/COBOL application. Unlike other techniques, such as embedded SQL, InstantSQL brings most of the advantages of dynamic SQL to bear without the complexity of directly calling the native database API or its ODBC counterpart. Based on ODBC, InstantSQL allows many direct ODBC functions to be called as well, for those instances where more complex functionality is desired.

Key Benefits

Leverage the power and flexibility of SQL from COBOL Simplify the COBOL code needed to perform data operations Ability to combine the power of a native database engine with the reliability of COBOL

Detailed Feature Overview

InstantSQL allows easy access to databases using Structured Query Language (SQL) from RM/COBOL. InstantSQL provides SQL connectivity from RM/COBOL applications to any Open Database Connectivity (ODBC)-compliant data source, including Relativity data sources. InstantSQL is implemented at compile time with a set of copy files and at runtime with a dynamic link library (DLL) or shared object (SO).

InstantSQL provides a set of statements that can be used in an RM/COBOL application to access databases using SQL.

Connection statements

Connect and disconnect from a data source

Query statements

Query a connected data source

Advanced statements

Bind columns and parameters; transactions

Status inquiry statements

Acquire InstantSQL state information

Browse statements

Browse available data sources and connected data source structure

Other Key Features

Instant SQL runtime component is freely distributable

Product Specifications and System Requirements

RM/COBOL v8.0 or later. ODBC version 2.0.12 or laterFor additional information please visit: www.microfocus.comCopyright © Micro Focus (IP) Limited 2009. All rights reserved. The software and information contained herein are proprietary to, and comprise valuable trade secrets of, Micro Focus (IP) Limited, which intends to preserve as trade secrets such software and information. This software is an unpublished copyright of Micro Focus and may not be used, copied, transmitted, or stored in any manner. This software and information or any other copies thereof may not be provided or otherwise made available to any other person. sDSISQL1209