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.2 Processing Local Files
2.2.1 Components
2.3 Processing Remote Files
2.3 Processing Remote Files
2.3.1 Components
2.4 Remote SQL Processing
2.4 Remote SQL Processing
2.4.1 Components
3 Creating Data Sources
3.1 Data Source Names (DSNs)
3.1 Data Source Names (DSNs)
To add a data source name
3.2 Defining the Data Source
3.2 Defining the Data Source
To modify data source parameters
To delete a data source name
3.3 Advanced Options
3.3 Advanced Options
3.4 Vision Options
3.4 Vision Options
3.5 Tracing Options
3.5 Tracing Options
3.6 Processing Remotely
3.6 Processing Remotely
3.7 File Aliases
3.7 File Aliases
To modify a file alias
To delete a file alias
3.8 Multicompany Support
3.8 Multicompany Support
3.8.1 Creating the Master DSN
3.8.1 Creating the Master DSN
To modify company information
To delete an individual company entry
3.8.2 Creating Individual Company-specific DSNs
3.8.2 Creating Individual Company-specific DSNs
3.9 Accessing Remote Files
3.9 Accessing Remote Files
4 Working With Windows Applications
4.1 Working With Windows Applications
4.1 Working With Windows Applications
To access data from Word 2000
To access data from Word 97
To access data from Excel 2000
To access data from Excel 97
To access data from Access 2000
To access data from Access 97
5 Writing Queries to Access Data
5.1 Writing Queries to Access Data
5.2 What to Consider
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 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.4 The AcuODBC Optimizer
5.5 SQL Reserved Words Recognized by AcuODBC
5.5 SQL Reserved Words Recognized by AcuODBC
5.6 Functions Supported 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 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 Using Directives
6.3.1 Sample Files and Examples
6.3.2 Syntax
6.3.3 AcuODBC HIDDEN Directive
6.3.4 AcuODBC READ-ONLY Directive
6.3.5 COMMENT Directive
6.3.6 DATE Directive
6.3.7 FILE Directive
6.3.8 NAME Directive
6.3.9 NUMERIC Directive
6.3.10 USE GROUP Directive
6.3.11 WHEN Directive
6.4 Encrypting XFD Files
6.4 Encrypting XFD Files
6.5 How AcuODBC Locates XFD Files
6.5 How AcuODBC Locates XFD Files
7 Troubleshooting
7.1 Overview of Errors
7.2 Native Vision Errors
7.3 Application Errors
7.4 AcuODBC Trace Files
7.4 AcuODBC Trace Files
To start AcuODBC's trace functions
7.5 General ODBC Trace Files
7.5 General ODBC Trace Files
To start the Microsoft ODBC trace function
8 The AcuODBC Server Environment
8.1 AcuODBC Server
8.2 Getting Started
8.3 AcuODBC Server Configuration Variables
8.3 AcuODBC Server Configuration Variables
8.3.1 ACCESS_FILE
8.3.2 ACUODBCS_PORT
8.3.3 DSN_DIRECTORY
8.4 System Security - The AcuAccess File
8.4 System Security - The AcuAccess File
8.4.1 Maintaining the AcuAccess file
8.4.2 Modifying the Server Access File
8.4.2 Modifying the Server Access File
Adding access records
Deleting access records
Modifying access records
Displaying access records
Exiting the Access Manager
8.5 AcuODBC Server Commands
8.5 AcuODBC Server Commands
Installing AcuODBC Server as a Service (Windows Only)
Starting AcuODBC Server as a Service or Daemon
Stopping the AcuODBC Server
Removing the acuodbcs Service (Windows Only)
8.5.1 acuodbcs
8.5.2 acuodbcs -access
8.5.3 acuodbcs -install
8.5.4 acuodbcs -kill
8.5.5 acuodbcs -query
8.5.6 acuodbcs -remove
8.5.7 acuodbcs -start
8.5.8 acuodbcs -version
9 Remote Data Sources
9.1 Creating Remote Data Sources
9.2 Configuring the Remote DSN on the Client
9.3 Configuring the Remote DSN on the Server
9.3 Configuring the Remote DSN on the Server
9.3.1 Configuring Remote Data Sources in Windows
9.3.1 Configuring Remote Data Sources in Windows
To configure a remote data source in Windows
To edit a remote data source in Windows
To delete a remote data source in Windows
9.3.2 Configuring Remote Data Sources in UNIX
9.3.2 Configuring Remote Data Sources in UNIX
9.3.3 The srvconfig.tcl Utility - Working in a Graphical Environment
9.3.3 The srvconfig.tcl Utility - Working in a Graphical Environment
Starting srvconfig.tcl
Editing remote DSNs using srvconfig.tcl
Deleting remote DSNs using srvconfig.tcl
9.3.4 The srvconfig.sh Utility - Working at the Command Line
9.3.4 The srvconfig.sh Utility - Working at the Command Line
Starting srvconfig.sh
Editing remote DSNs using srvconfig.sh
Deleting remote DSNs from the UNIX command line
A ODBC Conformance Levels
A.1 ODBC Conformance Levels
A.1 ODBC Conformance Levels
A.1.1 SQL Conformance
A.1.2 API Conformance
B Changes Between Releases
B.1 Changes from Version 5.1 to 5.2
B.1 Changes from Version 5.1 to 5.2
B.1.1 AcuODBC Server
B.1.2 NT Security Settings
B.1.3 Character Types
B.1.4 Non-numeric Data in a Numeric Field
B.2 Changes from Version 5.0 to Version 5.1
B.2 Changes from Version 5.0 to Version 5.1
B.2.1 Compatibility with Earlier Releases
B.2.2 User Interface
B.2.3 Data Type Differences
B.2.4 Floating Point Precision
B.2.5 COMP-5 Change
B.2.6 Signed Index
Glossary of Terms
Glossary of Terms
(c) Copyright Acucorp, Inc., 1997-2001. ALL RIGHTS RESERVED.
Acucorp, Acucobol, AcuBench, AcuConnect, AcuLaunch, AcuServer, AcuSQL, Acu4GL, and extend are trademarks of Acucorp, Inc. AcuODBC is a registered trademark of Acucorp, Inc. Acu4GL is protected by U.S. patent no. 5,640,550. Other brand and product names are trademarks or registered trademarks of their holders.