Copyright © 2000 MERANT International Limited. All rights
This document and the proprietary marks and names used herein are protected by international law.
MERANT has made every effort to ensure that this manual is correct and accurate but reserves the right to make changes without notice at its sole discretion at any time.
The software described in this document is supplied under a license and may be used or copied only in accordance with the terms of such license, and in particular any warranty of fitness of MERANT software products for any particular purpose is expressly excluded and in no event will MERANT be liable for any consequential losses.
Micro Focus® is a registered trademark and Form Designer, MERANT, Micro Focus COBOL and Net Express are trademarks of MERANT International Limited.
Microsoft®, Windows®, and Windows for Workgroups®, are registered trademarks of Microsoft Corporation.
Visual Basic and Windows NT are trademarks of Microsoft Corporation
IBM® and DB2® are registered trademarks of International Business Machines Corporation.
UNIX® is a registered trademark of X/Open Company Limited.
Oracle® is a registered trademark of Oracle Corporation.
Sybase is a trademark of Sybase, Inc.
Copyright© 1987-2000 MERANT International Limited
All Rights Reserved.
This book describes how you can use Net Express to create a COBOL application which uses embedded SQL to access a relational database. Net Express provides:
This book does not provide details about SQL syntax, error messages returned or any use of SQL outside of the COBOL environment. For details of these, refer to the documentation supplied by your database vendor.
This book is for Net Express COBOL programmers who want to create or modify COBOL applications which access relational databases using embedded SQL.
It is assumed that you are already familiar with both SQL and, if you are using OpenESQL, ODBC. If you are using the DB2 ECM, it is assumed that you are familiar with DB2. If you are using COBSQL, it is assumed that you are familiar with the Oracle or Sybase database that you are accessing.
The following type styles and conventions have been used in this book:
cat script_name | more
The italic text denotes a variable that you type as part of the command.
column_nameis like the
pattern_value, or is not like the
pattern_value, depending on the absence or presence of the optional word
column_name [NOT] LIKE pattern_value
This paragraph only applies to OpenESQL and not to DB2 or COBSQL.