Data Sheet
InstantSQL
OpenText 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 Key Benefits System Requirements
SQL, InstantSQL brings most of the advan ■ Leverage the power and flexibility of SQL ■ RM/COBOL v8.0 or later. ODBC version 2.0.12
tages of dynamic SQL to bear without the com from COBOL or later
plexity of directly calling the native database ■ Simplify the COBOL code needed to
API or its ODBC counterpart. Based on ODBC, perform data operations
InstantSQL allows many direct ODBC func
■ Ability to combine the power of a native
tions to be called as well, for those instances
where more complex functionality is desired. database engine with the reliability of
COBOL
Product Highlights
Key Features
Business Challenge InstantSQL allows easy access to databases
Today’s business climate includes a renewed using Structured Query Language (SQL) from
focus on driving down costs within the IT orga RM/COBOL. InstantSQL provides SQL con
nization. When multiple technologies are used nectivity from RM/COBOL applications to
to address a common business need there are any Open Database Connectivity (ODBC)-
unnecessary costs introduced into the man compliant data source, including Relativity
agement of those systems, building connec data sources. InstantSQL is implemented at
tions between them, and dealing with multiple compile time with a set of copy files and at run
vendors. A common area in which this is seen is time with a dynamic link library (DLL) or shared
data access. InstantSQL provides a simplified object (SO).
way of using popular, relational databases di
rectly from within your RM/COBOL application. InstantSQL provides a set of statements that
can be used in an RM/COBOL application to
Product Overview access databases using SQL.
InstantSQL provides a simplified but high per
formance way of using popular relational da Connection statements
tabases directly from within your RM/COBOL Connect and disconnect from a data source
application. Unlike other techniques, such as
embedded SQL, InstantSQL brings most of Query statements
the advantages of dynamic SQL to bear with Query a connected data source
out the complexity of directly calling the native
database API or its ODBC counterpart. Based Advanced statements
on ODBC, InstantSQL allows many direct Bind columns and parameters; transactions
ODBC functions to be called as well, for those
instances where more complex functionality Status inquiry statements
is desired. Acquire InstantSQL state information
Connect with Us
OpenText CEO Mark Barrenechea’s blog
Browse statements RELATIVITY
Browse available data sources and connected ODBC access to OpenText and RM/COBOL
data source structure data: Relativity® allows core data from sophis
ticated OpenText or RM/COBOL applications
Additional Product Information to be re-tooled as a full-featured relational da
The Instant SQL runtime component is freely tabase. The data can then be joined with other
distributable. disparate data and accessed by Windows-
based tools seamlessly and transparently.
Other Key Features
RM/COBOL’s runtime system is the core com XCENTRISITY®
ponent of a suite of products. Other solutions Web Server environment for your RM/COBOL
include: applications: BIS offers application develop
ers an opportunity to build Service Oriented
WOW EXTENSIONS Architecture (SOA) applications incorporating
Windows Object Workshop: WOW Exten- legacy business data and logic freely mixed
sions™ gives you an easy-to-use, integrated with the latest web languages and tools.
development environment that supports
screen design, coding, compiling, and testing Learn more at
in a modern visual environment. www.microfocus.com/opentext
INSTANTSQL
Database Access with RM/COBOL: Instant
SQL™ provides a simplified way of using pop
ular relational databases directly from within
your RM/COBOL application.
260-000107-001 | O | 03/23 | © 2023 Open Text
