Acucorp, Inc.


AcuODBC User's Guide
Version 6.0

1: Introduction

1.1 Overview
1.2 Product Requirements
1.3 What Is ODBC?
1.4 Front- and Back-end ODBC
1.5 Using AcuODBC
1.6 Technical Support

2: AcuODBC Architecture

2.1 AcuODBC Design
2.2 Processing Local Files
2.3 Local Processing of Remote Files
2.4 Remote SQL Processing
2.5 Comparing AcuODBC Server and AcuODBC with AcuServer

3: Creating Data Sources

3.1 Data Source Names (DSNs)
3.2 Defining the Data Source
3.2.1 Modifying Data Source Parameters
3.2.2 Deleting a Data Source Name
3.3 Advanced Options
3.4 Vision Options
3.5 Tracing Options
3.6 Processing Remotely
3.7 File Aliases
3.7.1 Modifying a File Alias
3.7.2 Deleting a File Alias
3.8 Multicompany Support
3.8.1 Creating the Master DSN
3.8.2 Creating Individual Company-specific DSNs
3.9 Accessing Remote Files

Back to top

4: Working With Windows Applications

4.1 Working With Windows Applications
4.1.1 Accessing Data From Word 97 and 2000
4.1.2 Accessing Data From Excel 97 and 2000
4.1.3 Accessing Data From Access 97 and 2000

5: Writing Queries to Access Data

5.1 Writing Queries to Access Data
5.2 What to Consider
5.2.1 COBOL vs. Application Language
5.2.2 How Relational Databases Organize Data
5.3 SQL Syntax Supported by AcuODBC
5.3.1 SELECT Command
5.3.2 JOIN Statements
5.3.3 INSERT Command
5.3.4 UPDATE Command
5.3.5 DELETE Command
5.4 The AcuODBC Optimizer
5.5 SQL Reserved Words Recognized by AcuODBC
5.6 Functions Supported by AcuODBC

6: Mapping COBOL Data Items and Database Fields

6.1 Data Dictionaries
6.2 XFD Files
6.2.1 How the Data Dictionary Is Formed
6.2.2 Defaults Used in XFD Files
6.2.3 Examples of Default Mapping
6.2.4 Summary of Dictionary Fields
6.2.5 Naming the XFD File
6.3 Using Directives
6.3.1 Sample Files and Examples
6.3.2 Directive Syntax
6.3.3 COMMENT Directive
6.3.4 DATE Directive
6.3.5 FILE Directive
6.3.6 HIDDEN Directive
6.3.7 NAME Directive
6.3.8 NUMERIC Directive
6.3.9 READ-ONLY Directive
6.3.10 USE GROUP Directive
6.3.11 WHEN Directive
6.4 Encrypting XFD Files
6.5 How AcuODBC Locates XFD Files

Back to top

7: Troubleshooting

7.1 Overview of Errors
7.2 Native Vision Errors
7.3 Application Errors
7.4 AcuODBC Trace Files
7.5 General ODBC Trace Files

8: The AcuODBC Server Environment

8.1 AcuODBC Server
8.2 Getting Started
8.3 System Security - The AcuAccess File
8.3.1 Using the Access File Manager Utility
8.3.2 Managing AcuAccess Records
8.4 AcuODBC Server Functions
8.4.1 AcuODBC Server Configuration Variables
8.4.2 Installing and Removing the acuodbcs Service (Windows only)
8.4.3 Determining Whether acuodbcs is Installed as a Windows Service
8.4.4 Starting and Stopping acuodbcs
8.5 The Data Source Configuration Utility
8.6 Checking Version Information

9: Remote Data Sources

9.1 Creating Remote Data Sources
9.2 Configuring the Remote DSN on a Windows Client
9.3 Configuring the Remote DSN on a Windows Server
9.4 Configuring Remote Data Sources in a UNIX Graphical Environment
9.5 Configuring Remote Data Sources from the UNIX Command Line
9.5.1 and the UNIX command-line environment
9.5.2 Configuring a DSN Using
9.5.3 Creating multicompany DSNs using

Back to top

A: ODBC Conformance Levels

A.1 ODBC Conformance Levels
A.1.1 SQL Conformance
A.1.2 API Conformance

Glossary of Terms

Copyright Acucorp, Inc., 1988-2003. All rights reserved.
ACUCOBOL, AcuBench, AcuServer, and AcuSQL are trademarks of Acucorp, Inc. Acucorp, Acu4GL, AcuConnect, AcuODBC, and extend are registered trademarks of Acucorp, Inc. "The new face of COBOL" is a service mark of Acucorp, Inc. Acu4GL is protected by U.S. patent 5,640,550, and AcuODBC is protected by U.S. patent 5,826,076. Other brand and product names are trademarks or registered trademarks of their respective holders.