Openaccess Sdk For Isam Programmer’s Guide

OpenAccess SDK for ISAM Programmer’s Guide
Copyright  1996-2003 Automation Technology, Inc. Part # OA-SDK-V500-DOC-PROG-ISAM All rights reserved. Printed in the USA This software documentation contains proprietary information of Automation Technology, Inc. (ATI); it is provided under a license agreement containing restrictions on use and disclosure and is also protected by copyright law. Reverseengineering of the software is prohibited. If this software/documentation is delivered to a U.S. Government Agency, then it is delivered with Restricted Rights and the following legend is applicable: Restricted Rights Legend Department of Defense: Use, duplication or disclosure by the Government is subject to restrictions as set forth in subparagraph (c)(1)(ii) of DFARS 252.227-7013, Rights inTechnical Data and Computer Software. Other Government Agencies : This software is delivered with “Restricted Rights,” as defined in FARS 52.227-14, Rights in Data - General, including Alternate III. The information in this documentation is subject to change without notice. If you find any problems in the documentation, please report them to us in writing. Automation Technology, Inc. does notwarrant that this documentation is error free. DISCLAIMER 1. ATI MAKES NO WARRANTY OR REPRESENTATION WHATSOEVER, EXPRESS OR IMPLIED INCLUDING ANY WARRANTY OR MERCHANTABILITY OR FITNESS OF ANY PURPOSE WITH RESPECT TO THE PROGRAM AND DOCUMENTATION; OR 2. ATI ASSUMES NO LIABILITY WHATSOEVER WITH RESPECT TO ANY USE OF THE PROGRAM OR ANY PORTION THEREOF OR WITH RESPECT TO ANY DAMAGES WHICH MAY RESULT FROMSUCH USE. OpenAccess is a trademark of Automation Technology, Inc. All other brand names are trademarks of their respective holders.

Preface
About this Manual
This document is written for the programmer developing a SQL interface to an ISAM database to allow SQL access from PCs and other platforms using Microsoft OLE DB, ODBC, or .NET compliant interfaces and Sun Microsystems JDBC compliantinterface. An ISAM database in the context of this document is either the Informix C-ISAM database or any data store that can be modeled as collection of records that can be accessed through an index and/or sequencially using the ISAM API documented in this document. This document provides detailed description of the configuration of the OpenAccess SDK for developing customized solutions for accessingISAM files. Specifically, this document covers the following topics: • • Architecture of the OpenAccess SDK for ISAM. Customizing for your specific application environment in terms of the data conversions and data dictionary.

Please refer to the OpenAccess SDK Programmer’s Guide and The OpenAccess SDK Programmer’s Reference for details on the operations of OpenAccess and how to write and IP. Thisdocument is divided into 3 chapters. Chapter 1 is an overview of developing a local or a client/server driver in Java. Chapter 2 lists the methods the IP exposes to the DAM. Chapter 3 lists methods that an IP uses when interacting with the DAM.

Notation Convention
The courier font is used for system-dependent keywords and commands to be typed by the user. The pipe character ‘|’ is used as ashortcut notation and separator between menus, sub-menus, and items. As an example: ‘File | Open’ means the Open option from the File menu.

Getting Technical Support
Technical support is available over the telephone, fax or Internet. Please send e-mail and file to ATI. Please provide the OpenAccess product and version when calling/writing for the technical support. Telephone FAX Internet408-350-7020 408-350-7021 support@atinet.com

Table of Contents
OVERVIEW .......................................................................................................... 1-1 OPENACCESS ISAM SDK ARCHITECTURE ............................................................. 2-1 ISAM IP OPERATIONS ..............................................................................................2-2 SCHEMA...