Index

$ in Indicator Area:

7.3.1 Syntax

\\acuodbc32:

To install AcuODBC in a single-tier environment

4.1 Installing the Sample Program

16- or 32-bit:

To install AcuODBC in a single-tier environment

32-bit:

2.2.1 Single-tier Components

Access:

1.4 Front- and Back-end ODBC

6.5.3 Access

5.1 Working With Windows Applications

To access data from Access

Access97:

1.1 Overview

1.4 Front- and Back-end ODBC

AccessBasic:

6.5.3 Access

Acu4GL for ODBC:

1.4 Front- and Back-end ODBC

Acucobol Orders Program:

4.1 Installing the Sample Program

ACUCOBOL-GT:

1.2 Product Requirements

AcuODBC Hidden directive:

7.3.2 AcuODBC Hidden Directive

AcuODBC Read-Only directive:

7.3.3 AcuODBC Read-Only Directive

ACUODBC.INI:

3.1 Data Source Names (DSNs)

acuodbcn.log:

3.4 Vision Options

AcuServer:

A.2 Multiple-Tier Installation

1.2 Product Requirements

2.3.1 Multitier Components

2.3 AcuODBC Multiple-Tier

ACUV32CL.DLL:

2.2.1 Single-tier Components

Add-Ins:

To access data from Excel

ANSI-compliant directive:

7.3.1 Syntax

API Conformance Level:

B.3 API Conformance

Application Programming Interface:

1.3 What is ODBC?

ASSIGN TO:

7.2.4 Naming the XFD

Buffers:

3.4 Vision Options

cancel a query:

6.5.4 Canceling a Query

COBOL vs. Application Language:

6.2.1 COBOL vs. Application Language

COMMENT ACUODBC HIDDEN:

3.2 Advanced Options

COMMENT ACUODBC READ-ONLY:

3.2 Advanced Options

Compilation Options:

3.2 Advanced Options

COPY REPLACING:

7.2 XFD Files

creating data source names:

3.1 Data Source Names (DSNs)

Crystal Reports:

1.1 Overview

1.4 Front- and Back-end ODBC

data dictionary directory:

3.2 Advanced Options

To add a data source name

data dictionary file name:

7.3.5 File Directive

data dictionary:

7.1 Data Dictionaries

2.2.1 Single-tier Components

3.1 Data Source Names (DSNs)

1.2 Product Requirements

2.3.1 Multitier Components

data source name:

3.1 Data Source Names (DSNs)

data source:

Remaining activities

DATE directive:

7.3.4 Date Directive

date format:

7.3.4 Date Directive

Debug Acucobol Orders Program:

4.1 Installing the Sample Program

Debug Options:

3.4 Vision Options

To initiate AcuODBC's Vision or SQL trace function

Default Map File:

3.2 Advanced Options

DELETE command:

6.3 SQL Syntax Supported by AcuODBC

6.3.3 DELETE Command

deleting file mapping definitions:

3.2 Advanced Options

directive syntax:

7.3.1 Syntax

directives:

7.3 Using Directives

DSN:

3.1 Data Source Names (DSNs)

duplicate field names:

7.2.3 Summary of Dictionary Fields

error message:

8.1 Overview of Errors

Excel/Visual Basic:

6.5.2 Excel

2.1 AcuODBC Design

Excel:

6.5.2 Excel

5.1 Working With Windows Applications

To access data from Excel

Excel97:

1.1 Overview

1.4 Front- and Back-end ODBC

field names:

7.3.6 Name Directive

fields with identical names:

7.2.3 Summary of Dictionary Fields

File Aliases:

3.2 Advanced Options

File Case:

3.2 Advanced Options

To add a data source name

FILE CONTROL section:

7.2.1 How the Data Dictionary is Formed

FILE directive:

7.3.5 File Directive

File Prefix:

3.2 Advanced Options

File Suffix:

3.2 Advanced Options

FILLER:

7.3.9 When Directive

7.2.2 Defaults Used in XFD Files

Font:

3.2 Advanced Options

-Fx:

7.2 XFD Files

1.2 Product Requirements

2.2.1 Single-tier Components

-Fxa:

7.2 XFD Files

2.2.1 Single-tier Components

1.2 Product Requirements

Get External Data:

To access data from Access

To access data from Excel

group items:

7.2.2 Defaults Used in XFD Files

guidelines and samples:

6.5 Guidelines and Samples

HIDDEN directive:

3.2 Advanced Options

I/O efficiency:

7.3.8 Use Group Directive

I/O statements:

7.3 Using Directives

Indicator Area:

7.3.1 Syntax

Informix:

1.4 Front- and Back-end ODBC

inner joins:

6.3.1 SELECT Command

INSERT command:

6.3.2 INSERT Command

6.3 SQL Syntax Supported by AcuODBC

International Character Handling:

3.2 Advanced Options

join statements:

6.3.1 SELECT Command

Julian Base Date:

3.2 Advanced Options

key fields:

7.2.1 How the Data Dictionary is Formed

7.2.2 Defaults Used in XFD Files

KEY IS phrase:

7.2.1 How the Data Dictionary is Formed

Literals:

6.3 SQL Syntax Supported by AcuODBC

local directory:

To add a data source name

Locks Per File:

3.4 Vision Options

Logical Name:

3.2 Advanced Options

Macro programming:

6.1 Writing Macros

macros:

6.1 Writing Macros

mail merge:

To access data from Word for Windows

master DSN:

To manage multi-company files

3.3 Multi-Company Support

Max. Files:

3.4 Vision Options

Max. Locks:

3.4 Vision Options

Microsoft Excel:

2.2.1 Single-tier Components

Microsoft Office 97:

1.3 What is ODBC?

Microsoft Office:

5.1 Working With Windows Applications

Microsoft Word97:

1.1 Overview

1.4 Front- and Back-end ODBC

MS Query:

1.1 Overview

1.4 Front- and Back-end ODBC

To access data from Word for Windows

5.1 Working With Windows Applications

2.1 AcuODBC Design

multi-company support:

3.3 Multi-Company Support

multiple directories:

To add a data source name

multiple record definitions:

7.3.9 When Directive

7.2.2 Defaults Used in XFD Files

multiple-tier architecture:

2.1 AcuODBC Design

2.3 AcuODBC Multiple-Tier

multiple-tier installation:

A.2 Multiple-Tier Installation

NAME directive:

7.3.6 Name Directive

native Vision error:

8.1 Overview of Errors

NUMERIC directive:

7.3.7 Numeric Directive

OCCURS clause:

7.2.2 Defaults Used in XFD Files

ODBC Administrator:

To add a data source name

To modify data source parameters

ODBC driver for ACUCOBOL-GT data:

2.2.1 Single-tier Components

ODBC driver manager:

2.3.1 Multitier Components

1.2 Product Requirements

2.2.1 Single-tier Components

ODBC icon:

To add a data source name

ODBC trace:

8.4 General ODBC Trace Files

ODBC.INI:

3.1 Data Source Names (DSNs)

ODBC32.DLL:

2.2.1 Single-tier Components

OEM character set:

3.2 Advanced Options

Open Database Connectivity:

1.1 Overview

2.1 AcuODBC Design

1.3 What is ODBC?

Oracle:

1.4 Front- and Back-end ODBC

OTHER:

7.3.9 When Directive

outer joins:

6.3.1 SELECT Command

Password Request:

3.2 Advanced Options

performance:

To add a data source name

Physical Name:

3.2 Advanced Options

Pointer to existing DSN:

To manage multi-company files

Procedure Division:

7.3 Using Directives

qualification:

7.2.3 Summary of Dictionary Fields

Query Sample Program:

4.1 Installing the Sample Program

4.5 Running the Query Sample Program

Read Only:

3.2 Advanced Options

read/write versions of AcuODBC:

3.2 Advanced Options

ReadMe:

4.1 Installing the Sample Program

READ-ONLY directive:

3.2 Advanced Options

REDEFINES clause:

7.3.9 When Directive

3.2 Advanced Options

7.2.2 Defaults Used in XFD Files

registration:

To install AcuODBC in a single-tier environment

Relational Databases:

6.2.2 How Relational Databases Organize Data

Release notes:

4.1 Installing the Sample Program

remote directory:

To add a data source name

Replacing characters:

To manage multi-company files

Return Data to Excel:

To access data from Excel

sample macros:

6.5 Guidelines and Samples

Sample Orders Program:

4.2 The Sample Orders Program

sample program:

4.1 Installing the Sample Program

SELECT command:

7.2.4 Naming the XFD

6.3 SQL Syntax Supported by AcuODBC

3.2 Advanced Options

7.2.1 How the Data Dictionary is Formed

6.3.1 SELECT Command

self-joins:

6.3.1 SELECT Command

Setup:

To install AcuODBC in a single-tier environment

Signed Index:

3.2 Advanced Options

single-tier architecture:

2.1 AcuODBC Design

2.2 AcuODBC Single-Tier

single-tier:

A.1.1 Hardware and Software Requirements

source-code control:

7.2 XFD Files

SQL Conformance Level:

B.2 SQL Conformance

SQL error:

8.1 Overview of Errors

SQL reserved words:

6.4 SQL Reserved Words Supported by AcuODBC

SQL Syntax:

6.3 SQL Syntax Supported by AcuODBC

SQL trace:

3.4 Vision Options

8.3 AcuODBC Trace Files

sql.log:

To initiate the Microsoft ODBC trace function

SQL:

6.1 Writing Macros

2.2.1 Single-tier Components

SQLSTATE ODBC error:

8.1 Overview of Errors

Standard Aggregate Functions:

6.3.1 SELECT Command

Structured Query Language:

6.1 Writing Macros

2.1 AcuODBC Design

tablename:

7.3.9 When Directive

TCP/IP:

2.2.1 Single-tier Components

2.3 AcuODBC Multiple-Tier

trace files:

8.3 AcuODBC Trace Files

unInstallSHIELD:

4.1 Installing the Sample Program

unsigned integer:

7.3.7 Numeric Directive

UPDATE command:

6.3.4 UPDATE Command

6.3 SQL Syntax Supported by AcuODBC

USE GROUP directive:

7.3.4 Date Directive

7.3.8 Use Group Directive

Vision ODBC driver:

To install AcuODBC in a single-tier environment

Vision options:

3.4 Vision Options

8.3 AcuODBC Trace Files

Vision parameters:

3.4 Vision Options

Vision trace:

8.3 AcuODBC Trace Files

3.4 Vision Options

Vision Version 4:

1.2 Product Requirements

visionn.log:

3.4 Vision Options

Visual Basic:

1.4 Front- and Back-end ODBC

1.1 Overview

WBODBC.WLL:

6.5.1 Word for Windows

WHEN directive:

7.3.9 When Directive

Windows 95:

2.2.1 Single-tier Components

1.2 Product Requirements

Windows 98:

A.1.1 Hardware and Software Requirements

1.2 Product Requirements

2.2.1 Single-tier Components

Windows control panel:

To add a data source name

Windows NT:

2.2.1 Single-tier Components

Windows NT Workstation/Server:

1.2 Product Requirements

WINSOCK.DLL:

A.2 Multiple-Tier Installation

Word for Windows:

6.5.1 Word for Windows

5.1 Working With Windows Applications

To access data from Word for Windows

WordBasic:

2.1 AcuODBC Design

6.5.1 Word for Windows

Write Permission:

3.2 Advanced Options

XFD files:

To add a data source name

1.2 Product Requirements

XFD name:

7.2.4 Naming the XFD

xfdcrypt utility:

7.3.2 AcuODBC Hidden Directive

xfdrmt.dir:

7.4 How AcuODBC Locates XFD Files

To add a data source name

XFDs:

7.1 Data Dictionaries

XLODBC.XLA:

6.5.2 Excel