Contents

Index

A IndexB IndexC IndexD IndexE IndexF IndexG IndexH IndexI IndexJ IndexK IndexL IndexM IndexN IndexO IndexP IndexQ IndexR IndexS IndexT IndexU IndexV IndexW IndexX IndexY IndexZ Index
$, directive syntax:
7.3.1 Syntax
*, directive syntax:
7.3.1 Syntax

A

Access 2000 and AcuODBC:
To access data from Access 2000
Access 7.0 and AcuODBC:
To access data from Access Version 7.0
Accessing:
2.3 AcuODBC Multiple-Tier
2.2 AcuODBC Single-Tier
Accessing:Local files:
2.2 AcuODBC Single-Tier
Accessing:Remote files:
2.3 AcuODBC Multiple-Tier
Active Transaction Debug Option:
3.4 Vision Options
Acu4GL for ODBC:
1.4 Front- and Back-end ODBC
Acucorp Orders Sample Program:
4.2 The Sample Orders Program
4.1 Locating the Sample Program
ACUODBC Hidden directive:
7.3.2 AcuODBC Hidden Directive
ACUODBC READ-ONLY directive:
7.3.3 AcuODBC Read-Only Directive
AcuODBC Trace Debug Option:
3.4 Vision Options
ACUODBC.INI configuration file:
3.1 Data Source Names (DSNs)
AcuODBC:
To access data from Word 2000
To access data from Word for Windows Version 7.0
To access data from Excel 2000
To access data from Excel Version 7.0
2.1 AcuODBC Design
To access data from Access 2000
1.2 Product Requirements
To access data from Access Version 7.0
6.3 SQL Syntax Supported by AcuODBC
6.3.1 SELECT Command
6.3.5 The AcuODBC Optimizer
6.4 SQL Reserved Words Supported by AcuODBC
1.1 Overview
3.3 Multi-Company Support
5.1 Working With Windows Applications
A.1 ODBC Conformance Levels
7.3.4 Date Directive
8.4 AcuODBC Trace Files
AcuODBC:Access 2000:
To access data from Access 2000
AcuODBC:Access 7.0:
To access data from Access Version 7.0
AcuODBC:Arithmetic Functions:
6.3.1 SELECT Command
AcuODBC:Commands supported:
A.1 ODBC Conformance Levels
AcuODBC:Design.:
2.1 AcuODBC Design
AcuODBC:Directives.:
7.3.4 Date Directive
AcuODBC:Excel 2000:
To access data from Excel 2000
AcuODBC:Excel 7.0:
To access data from Excel Version 7.0
AcuODBC:Introduction:
1.1 Overview
AcuODBC:Join statements.:
6.3.1 SELECT Command
AcuODBC:Logical operators:
6.3.1 SELECT Command
AcuODBC:Multi-company support:
3.3 Multi-Company Support
AcuODBC:Optimizer:
6.3.5 The AcuODBC Optimizer
AcuODBC:Overview:
1.1 Overview
AcuODBC:Reserved words, SQL:
6.4 SQL Reserved Words Supported by AcuODBC
AcuODBC:SQL syntax supported:
6.3 SQL Syntax Supported by AcuODBC
AcuODBC:Standard Aggregate Functions:
6.3.1 SELECT Command
AcuODBC:String Functions:
6.3.1 SELECT Command
AcuODBC:System requirements:
1.2 Product Requirements
AcuODBC:Trace files:
8.4 AcuODBC Trace Files
AcuODBC:Word 2000:
To access data from Word 2000
AcuODBC:Word 7.0:
To access data from Word for Windows Version 7.0
AcuODBC:Working with Windows applications:
5.1 Working With Windows Applications
acuodbcn.log file:
3.4 Vision Options
To initiate AcuODBC's Vision or AcuODBC trace function
AcuServer Parameters:
3.4 Vision Options
AcuServer Parameters:Default Timeout:
3.4 Vision Options
AcuServer Parameters:Server Port:
3.4 Vision Options
ACUV32.DLL driver:
2.2.1 Single-tier Components
Adding Data Source Names:
To add a data source name
Advanced Options, Data Source Names:
3.2 Advanced Options
Advanced Options, Data Source Names:Accessing:
3.2 Advanced Options
Advanced Options, Data Source Names:Allowing Strings Not Null:
3.2 Advanced Options
Advanced Options, Data Source Names:Compilation Options:
3.2 Advanced Options
Advanced Options, Data Source Names:Empty fields:
3.2 Advanced Options
Advanced Options, Data Source Names:File Case field:
3.2 Advanced Options
Advanced Options, Data Source Names:File Prefix field:
3.2 Advanced Options
Advanced Options, Data Source Names:File Suffix field:
3.2 Advanced Options
Advanced Options, Data Source Names:Font field:
3.2 Advanced Options
Advanced Options, Data Source Names:Julian Base Date field:
3.2 Advanced Options
Advanced Options, Data Source Names:Password Request field:
3.2 Advanced Options
Advanced Options, Data Source Names:Read Only field:
3.2 Advanced Options
Advanced Options, Data Source Names:Signed Index field:
3.2 Advanced Options
Aggregate Functions, Standard:
6.3.1 SELECT Command
Allowing Strings Not Null, advanced option:
3.2 Advanced Options
Alphanumeric literals, SQL syntax:
6.3 SQL Syntax Supported by AcuODBC
ANSI-compliant directives:
7.3.1 Syntax
API and ODBC:
1.3 What is ODBC?
API Conformance Level:
A.3 API Conformance
Application errors:
8.3 Application Errors
Application language vs COBOL, writing queries:
6.2.1 COBOL vs. Application Language
Application Programming Interface.:
1.3 What is ODBC?
Applications, working with Windows:
5.1 Working With Windows Applications
Architecture, AcuODBC:
2.2 AcuODBC Single-Tier
2.3 AcuODBC Multiple-Tier
2.1 AcuODBC Design
Architecture, AcuODBC:Multiple-tier:
2.3 AcuODBC Multiple-Tier
Architecture, AcuODBC:Overview:
2.1 AcuODBC Design
Architecture, AcuODBC:Single-tier:
2.2 AcuODBC Single-Tier
Arithmetic Functions:
6.3.1 SELECT Command
ASSIGN variable, XFD files:
7.2.4 Naming the XFD

B

Back end, ODBC:
1.4 Front- and Back-end ODBC
Bars, vertical:
6.3 SQL Syntax Supported by AcuODBC
Brackets, SQL syntax:
6.3 SQL Syntax Supported by AcuODBC
Buffers Vision Parameter, defining:
3.4 Vision Options

C

Case, upper:
6.3 SQL Syntax Supported by AcuODBC
Character Handling, International:
3.2 Advanced Options
Character Handling, International:Default Map File:
3.2 Advanced Options
Character Handling, International:Mapping:
3.2 Advanced Options
Character set, OEM:
3.2 Advanced Options
Characters, other:
6.3 SQL Syntax Supported by AcuODBC
Characters, replacing:
To manage multi-company files
COBOL vs application language, writing queries:
6.2.1 COBOL vs. Application Language
Commands, AcuODBC supported:
A.1 ODBC Conformance Levels
Commands, SQL syntax:
6.3.4 UPDATE Command
6.3.3 DELETE Command
6.3 SQL Syntax Supported by AcuODBC
6.3.1 SELECT Command
6.3.2 INSERT Command
Commands, SQL syntax:DELETE:
6.3 SQL Syntax Supported by AcuODBC
6.3.3 DELETE Command
Commands, SQL syntax:INSERT:
6.3 SQL Syntax Supported by AcuODBC
6.3.2 INSERT Command
Commands, SQL syntax:SELECT:
6.3 SQL Syntax Supported by AcuODBC
6.3.1 SELECT Command
Commands, SQL syntax:UPDATE:
6.3.4 UPDATE Command
6.3 SQL Syntax Supported by AcuODBC
COMMENT ACUODBC HIDDEN directive:
3.2 Advanced Options
COMMENT ACUODBC READ-ONLY directive:
3.2 Advanced Options
Compilation Options, advanced option:
3.2 Advanced Options
Components, architecture:
2.2.1 Single-tier Components
2.3.1 Multi-tier Components
Components, architecture:Multiple-tier:
2.3.1 Multi-tier Components
Components, architecture:Single-tier:
2.2.1 Single-tier Components
Configuration files:
3.1 Data Source Names (DSNs)
Configuration files:ACUODBC.INI:
3.1 Data Source Names (DSNs)
Configuration files:ODBC.INI:
3.1 Data Source Names (DSNs)
Conformance levels:
A.3 API Conformance
A.2 SQL Conformance
A.1 ODBC Conformance Levels
Conformance levels:API:
A.3 API Conformance
Conformance levels:ODBC:
A.1 ODBC Conformance Levels
Conformance levels:SQL:
A.2 SQL Conformance
Considerations, writing queries:
6.2 What To Consider
Contents, document:
1.1 Overview
Creating:
7.2 XFD Files
4.4 The Sample Data Source Name
3.1 Data Source Names (DSNs)
Creating:Data Source Names:
3.1 Data Source Names (DSNs)
Creating:Sample Data Source Name:
4.4 The Sample Data Source Name
Creating:XFD files:
7.2 XFD Files

D

Data dictionary directories:
To add a data source name
Data dictionary directories:Local:
To add a data source name
Data dictionary directories:Multiple:
To add a data source name
Data dictionary directories:Remote:
To add a data source name
Data dictionary:
7.1 Data Dictionaries
7.2.1 How the Data Dictionary is Formed
7.2.2.1 Examples
7.2.3 Summary of Dictionary Fields
2.2.1 Single-tier Components
Data dictionary:Formation:
7.2.1 How the Data Dictionary is Formed
7.2.2.1 Examples
Data dictionary:Overview:
7.1 Data Dictionaries
Data dictionary:Summary of fields:
7.2.3 Summary of Dictionary Fields
Data Source Administrator, ODBC:
To add a data source name
Data Source Administrator, ODBC:File DSN:
To add a data source name
Data Source Administrator, ODBC:Overview:
To add a data source name
Data Source Administrator, ODBC:System DSN:
To add a data source name
Data Source Administrator, ODBC:User DSN:
To add a data source name
Data Source Names:
To manage multi-company files
3.3 Multi-Company Support
To add a data source name
3.2 Advanced Options
3.1 Data Source Names (DSNs)
To delete a data source name
4.4 The Sample Data Source Name
Data Source Names:Adding:
To add a data source name
Data Source Names:Advanced Options:
3.2 Advanced Options
Data Source Names:Creating a sample DSN:
4.4 The Sample Data Source Name
Data Source Names:Creating:
3.1 Data Source Names (DSNs)
Data Source Names:Deleting:
To delete a data source name
Data Source Names:File:
To add a data source name
Data Source Names:Master DSNs:
3.3 Multi-Company Support
Data Source Names:Pointing to existing DSNs:
To manage multi-company files
Data Source Names:System:
To add a data source name
Data Source Names:User:
To add a data source name
Data source parameters, modifying:
To modify data source parameters
Databases, relational:
6.2.2 How Relational Databases Organize Data
DATE directive:
7.3.4 Date Directive
DATE directive:Group items:
7.3.4 Date Directive
DATE directive:Julian dates:
7.3.4 Date Directive
DATE directive:Syntax:
7.3.4 Date Directive
Dates, Julian:
7.3.4 Date Directive
Debug Acucorp Orders Sample Program:
4.1 Locating the Sample Program
Debug Options:
3.4 Vision Options
Debug Options:Active Transaction:
3.4 Vision Options
Debug Options:AcuODBC Trace:
3.4 Vision Options
Debug Options:Vision Trace:
3.4 Vision Options
Default Map File, International Character Handling:
3.2 Advanced Options
Default Timeout, AcuServer parameter:
3.4 Vision Options
Defaults, XFD files:
7.2.2 Defaults Used in XFD Files
Defining:
3.4 Vision Options
Defining:Buffers Vision Parameter:
3.4 Vision Options
Defining:Locks Per File Vision Parameter:
3.4 Vision Options
Defining:Max Files Vision Parameter:
3.4 Vision Options
Defining:Max Locks Vision Parameter:
3.4 Vision Options
Defining:Trace files:
3.4 Vision Options
Defining:Vision options:
3.4 Vision Options
Definitions, multiple record:
7.3.9 When Directive
7.2.2 Defaults Used in XFD Files
DELETE command:
6.3.3 DELETE Command
6.3 SQL Syntax Supported by AcuODBC
DELETE command:Overview:
6.3.3 DELETE Command
DELETE command:SQL syntax:
6.3 SQL Syntax Supported by AcuODBC
Deleting:
3.2 Advanced Options
To delete a data source name
Deleting:Data Source Names:
To delete a data source name
Deleting:File Mapping Definitions, File Alias:
3.2 Advanced Options
Design, AcuODBC.:
2.1 AcuODBC Design
Dictionary, data:
7.2.1 How the Data Dictionary is Formed
7.2.2.1 Examples
7.2.3 Summary of Dictionary Fields
2.2.1 Single-tier Components
7.1 Data Dictionaries
To add a data source name
Dictionary, data:Directories:
To add a data source name
Dictionary, data:Formation:
7.2.1 How the Data Dictionary is Formed
7.2.2.1 Examples
Dictionary, data:Overview:
7.1 Data Dictionaries
Dictionary, data:Summary of fields:
7.2.3 Summary of Dictionary Fields
Directives, XFD files:
7.3 Using Directives
7.3.5 File Directive
7.3.9 When Directive
7.3.3 AcuODBC Read-Only Directive
7.3.4 Date Directive
7.3.1 Syntax
7.3.2 AcuODBC Hidden Directive
7.3.6 Name Directive
7.3.7 Numeric Directive
7.3.8 Use Group Directive
Directives, XFD files:$ in indicator area:
7.3.1 Syntax
Directives, XFD files:* in indicator area:
7.3.1 Syntax
Directives, XFD files:ACUODBC Hidden:
7.3.2 AcuODBC Hidden Directive
Directives, XFD files:ACUODBC READ-ONLY:
7.3.3 AcuODBC Read-Only Directive
Directives, XFD files:ANSI compliant:
7.3.1 Syntax
Directives, XFD files:DATE:
7.3.4 Date Directive
Directives, XFD files:FILE:
7.3.5 File Directive
Directives, XFD files:NAME:
7.3.6 Name Directive
Directives, XFD files:NUMERIC:
7.3.7 Numeric Directive
Directives, XFD files:Overview:
7.3 Using Directives
Directives, XFD files:Syntax:
7.3.1 Syntax
Directives, XFD files:USE GROUP:
7.3.4 Date Directive
7.3.8 Use Group Directive
Directives, XFD files:WHEN:
7.3.9 When Directive
Directives:
3.2 Advanced Options
Directives:COMMENT ACUODBC HIDDEN:
3.2 Advanced Options
Directives:COMMENT ACUODBC READ-ONLY:
3.2 Advanced Options
Directories, data dictionary:
To add a data source name
Directories, data dictionary:Local:
To add a data source name
Directories, data dictionary:Multiple:
To add a data source name
Directories, data dictionary:Remote:
To add a data source name
Document contents:
1.1 Overview
Driver for ACUCOBOL-GT data, ODBC:
2.2.1 Single-tier Components
Driver manager, ODBC:
2.2.1 Single-tier Components
DSNs.:
3.1 Data Source Names (DSNs)

E

Ellipses, SQL syntax:
6.3 SQL Syntax Supported by AcuODBC
Empty fields:
3.2 Advanced Options
Errors:
8.1 Overview of Errors
8.2 Native Vision Errors
8.3 Application Errors
Errors:Application:
8.3 Application Errors
Errors:Overview:
8.1 Overview of Errors
Errors:Vision:
8.2 Native Vision Errors
Examples, data dictionary formation:
7.2.2.1 Examples
Excel 2000 and AcuODBC:
To access data from Excel 2000
Excel 7.0 and AcuODBC:
To access data from Excel Version 7.0
Existing DSNs, pointing to:
To manage multi-company files

F

Fields:
7.2.3 Summary of Dictionary Fields
7.3.6 Name Directive
7.2.2 Defaults Used in XFD Files
2.2.1 Single-tier Components
7.1 Data Dictionaries
7.2 XFD Files
Fields:Dictionary, summary:
7.2.3 Summary of Dictionary Fields
Fields:Identical names:
7.2.2 Defaults Used in XFD Files
Fields:Mapping with XFD files:
7.2 XFD Files
Fields:Record mapping:
7.1 Data Dictionaries
2.2.1 Single-tier Components
Fields:Unique names:
7.3.6 Name Directive
File Alias:
3.2 Advanced Options
File Alias:Deleting File Mapping Definitions:
3.2 Advanced Options
File Alias:Logical Name field:
3.2 Advanced Options
File Alias:Physical Name field:
3.2 Advanced Options
File Alias:Write Permission field:
3.2 Advanced Options
File Case, advanced option:
3.2 Advanced Options
FILE directive:
7.3.5 File Directive
File DSN:
To add a data source name
File Prefix, advanced option:
3.2 Advanced Options
File Suffix, advanced option:
3.2 Advanced Options
Files, accessing:
2.2 AcuODBC Single-Tier
2.3 AcuODBC Multiple-Tier
Files, accessing:Local:
2.2 AcuODBC Single-Tier
Files, accessing:Remote:
2.3 AcuODBC Multiple-Tier
Files, configuration:
3.1 Data Source Names (DSNs)
Files, configuration:ACUODBC.INI:
3.1 Data Source Names (DSNs)
Files, configuration:ODBC.INI:
3.1 Data Source Names (DSNs)
Files, log:
To initiate the Microsoft ODBC trace function
3.4 Vision Options
To initiate AcuODBC's Vision or AcuODBC trace function
Files, log:acuodbcn.log:
3.4 Vision Options
To initiate AcuODBC's Vision or AcuODBC trace function
Files, log:odbctrac.dll:
To initiate the Microsoft ODBC trace function
Files, log:sql.log:
To initiate the Microsoft ODBC trace function
Files, log:visionn.log:
3.4 Vision Options
To initiate AcuODBC's Vision or AcuODBC trace function
Files, managing multi-company:
To manage multi-company files
Files, managing multi-company:Existing DSNs:
To manage multi-company files
Files, managing multi-company:Getting started:
To manage multi-company files
Files, managing multi-company:Replacing characters:
To manage multi-company files
Files, trace:
To initiate AcuODBC's Vision or AcuODBC trace function
8.5 General ODBC Trace Files
8.4 AcuODBC Trace Files
To initiate the Microsoft ODBC trace function
3.4 Vision Options
Files, trace:acuodbc.log:
3.4 Vision Options
Files, trace:acuodbcn.log:
To initiate AcuODBC's Vision or AcuODBC trace function
Files, trace:Defining:
3.4 Vision Options
Files, trace:General:
8.5 General ODBC Trace Files
Files, trace:odbctrac.dll:
To initiate the Microsoft ODBC trace function
Files, trace:sql.log:
To initiate the Microsoft ODBC trace function
Files, trace:Starting AcuODBC trace function:
To initiate AcuODBC's Vision or AcuODBC trace function
Files, trace:Starting MS trace function:
To initiate the Microsoft ODBC trace function
Files, trace:Troubleshooting:
8.5 General ODBC Trace Files
8.4 AcuODBC Trace Files
Files, trace:visionn.log:
3.4 Vision Options
To initiate AcuODBC's Vision or AcuODBC trace function
Files, XFD:
7.4 How AcuODBC Locates XFD Files
7.2 XFD Files
7.2.2 Defaults Used in XFD Files
7.2.4 Naming the XFD
7.3 Using Directives
Files, XFD:ASSIGN variable:
7.2.4 Naming the XFD
Files, XFD:Creating:
7.2 XFD Files
Files, XFD:Data dictionaries:
7.2 XFD Files
Files, XFD:Defaults:
7.2.2 Defaults Used in XFD Files
Files, XFD:Directives:
7.3 Using Directives
Files, XFD:FILLER data items:
7.2.2 Defaults Used in XFD Files
Files, XFD:Group items:
7.2.2 Defaults Used in XFD Files
Files, XFD:Identical field names:
7.2.2 Defaults Used in XFD Files
Files, XFD:KEY IS phrase:
7.2.2 Defaults Used in XFD Files
Files, XFD:Locating:
7.4 How AcuODBC Locates XFD Files
Files, XFD:Mapping fields:
7.2 XFD Files
Files, XFD:Multiple record definitions:
7.2.2 Defaults Used in XFD Files
Files, XFD:Naming:
7.2.4 Naming the XFD
Files, XFD:OCCURS clause:
7.2.2 Defaults Used in XFD Files
Files, XFD:REDEFINES clause:
7.2.2 Defaults Used in XFD Files
FILLER clause, WHEN directive:
7.3.9 When Directive
FILLER data items, XFD files:
7.2.2 Defaults Used in XFD Files
Font, advanced option:
3.2 Advanced Options
Formation, data dictionaries:
7.2.1 How the Data Dictionary is Formed
7.2.2.1 Examples
Front end, ODBC:
1.4 Front- and Back-end ODBC
Full outer joins:
6.3.1 SELECT Command
Functions:
6.3.1 SELECT Command
Functions:Arithmetic:
6.3.1 SELECT Command
Functions:Standard Aggregate:
6.3.1 SELECT Command
Functions:String:
6.3.1 SELECT Command

G

General trace files:
8.5 General ODBC Trace Files
Generating SQL:
2.1 AcuODBC Design
Generating SQL:Using MS Query to generate:
2.1 AcuODBC Design
Generating SQL:Writing programs:
2.1 AcuODBC Design
Getting help:
1.5 Technical Support
Group items:
7.2.2 Defaults Used in XFD Files
7.3.4 Date Directive
Group items:DATE directive:
7.3.4 Date Directive
Group items:XFD files:
7.2.2 Defaults Used in XFD Files

H

Help, getting:
1.5 Technical Support
How data dictionaries are formed:
7.2.1 How the Data Dictionary is Formed
7.2.2.1 Examples

I

I/O efficiency, USE GROUP directive:
7.3.8 Use Group Directive
Identical field names, XFD files:
7.2.2 Defaults Used in XFD Files
Indexes, optimizing:
6.3.5 The AcuODBC Optimizer
Inner join statement:
6.3.1 SELECT Command
Input/Output efficiency, USE GROUP directive:
7.3.8 Use Group Directive
INSERT command:
6.3 SQL Syntax Supported by AcuODBC
6.3.2 INSERT Command
INSERT command:Overview:
6.3.2 INSERT Command
INSERT command:SQL syntax:
6.3 SQL Syntax Supported by AcuODBC
Integers, unsigned:
7.3.7 Numeric Directive
International Character Handling:
3.2 Advanced Options
International Character Handling:Default Map File:
3.2 Advanced Options
International Character Handling:Mapping:
3.2 Advanced Options
Introduction, AcuODBC:
1.1 Overview
Items:
7.2.2 Defaults Used in XFD Files
Items:FILLER:
7.2.2 Defaults Used in XFD Files
Items:Group:
7.2.2 Defaults Used in XFD Files

J

Join statements:
6.3.1 SELECT Command
Join statements:Full outer joins:
6.3.1 SELECT Command
Join statements:Inner joins:
6.3.1 SELECT Command
Join statements:Left outer joins:
6.3.1 SELECT Command
Join statements:Right outer joins:
6.3.1 SELECT Command
Julian Base Date, advanced option:
3.2 Advanced Options
Julian dates, DATE directive:
7.3.4 Date Directive

K

KEY IS phrase, XFD files:
7.2.2 Defaults Used in XFD Files

L

Left outer join statement:
6.3.1 SELECT Command
Levels, conformance:
A.3 API Conformance
A.2 SQL Conformance
A.1 ODBC Conformance Levels
Levels, conformance:API:
A.3 API Conformance
Levels, conformance:ODBC:
A.1 ODBC Conformance Levels
Levels, conformance:SQL:
A.2 SQL Conformance
Literals:
6.3 SQL Syntax Supported by AcuODBC
Literals:Alphanumeric:
6.3 SQL Syntax Supported by AcuODBC
Literals:Nonnumeric:
6.3 SQL Syntax Supported by AcuODBC
Literals:Numeric:
6.3 SQL Syntax Supported by AcuODBC
Local directories, data dictionary:
To add a data source name
Local files, accessing:
2.2 AcuODBC Single-Tier
Locating XFD files:
7.4 How AcuODBC Locates XFD Files
Locks Per File Vision Parameter, defining:
3.4 Vision Options
Log files:
To initiate the Microsoft ODBC trace function
To initiate AcuODBC's Vision or AcuODBC trace function
3.4 Vision Options
Log files:acuodbcn.log:
To initiate AcuODBC's Vision or AcuODBC trace function
3.4 Vision Options
Log files:odbctrac.dll:
To initiate the Microsoft ODBC trace function
Log files:sql.log:
To initiate the Microsoft ODBC trace function
Log files:visionn.log:
3.4 Vision Options
To initiate AcuODBC's Vision or AcuODBC trace function
LogBufferSize Transaction Parameter:
3.4 Vision Options
LogDevice Transaction Parameter:
3.4 Vision Options
LogDir Transaction Parameter:
3.4 Vision Options
LogEncryption Transaction Parameter:
3.4 Vision Options
LogFile Transaction Parameter:
3.4 Vision Options
Logging Transaction Parameter:
3.4 Vision Options
Logical Name, File Alias:
3.2 Advanced Options
Logical operators:
6.3.1 SELECT Command

M

Managing drivers, ODBC:
2.2.1 Single-tier Components
Managing multi-company files:
To manage multi-company files
Managing multi-company files:Existing DSNs:
To manage multi-company files
Managing multi-company files:Getting started:
To manage multi-company files
Managing multi-company files:Replacing characters:
To manage multi-company files
Mapping fields:
2.2.1 Single-tier Components
7.2 XFD Files
7.1 Data Dictionaries
Mapping fields:And records:
2.2.1 Single-tier Components
7.1 Data Dictionaries
Mapping fields:XFD files:
7.2 XFD Files
Mapping International Character Sets:
3.2 Advanced Options
Master DSNs:
3.3 Multi-Company Support
Max Files Vision Parameter, defining:
3.4 Vision Options
Max Locks Vision Parameter, defining:
3.4 Vision Options
Modifying data source parameters:
To modify data source parameters
MS ODBC:
2.2.1 Single-tier Components
MS Query, generating SQL:
2.1 AcuODBC Design
Multi-company files, managing:
To manage multi-company files
Multi-company files, managing:Existing DSNs:
To manage multi-company files
Multi-company files, managing:Getting started:
To manage multi-company files
Multi-company files, managing:Replacing characters:
To manage multi-company files
Multi-company support:
3.3 Multi-Company Support
Multiple directories, data dictionary:
To add a data source name
Multiple record definitions:
7.2.2 Defaults Used in XFD Files
7.3.9 When Directive
Multiple-tier architecture:
2.2 AcuODBC Single-Tier
2.3 AcuODBC Multiple-Tier
2.3.1 Multi-tier Components
Multiple-tier architecture:Components:
2.3.1 Multi-tier Components
Multiple-tier architecture:Overview:
2.3 AcuODBC Multiple-Tier
2.2 AcuODBC Single-Tier

N

NAME directive:
7.3.6 Name Directive
Names, Data Source.:
3.1 Data Source Names (DSNs)
Names, field:
7.3.6 Name Directive
7.2.2 Defaults Used in XFD Files
Names, field:Identical:
7.2.2 Defaults Used in XFD Files
Names, field:Unique:
7.3.6 Name Directive
Naming XFD files:
7.2.4 Naming the XFD
Nonnumeric literals, SQL syntax:
6.3 SQL Syntax Supported by AcuODBC
NULL values, WHEN directive:
7.3.9 When Directive
NUMERIC directive:
7.3.7 Numeric Directive
Numeric literals, SQL syntax:
6.3 SQL Syntax Supported by AcuODBC

O

OCCURS clause, XFD files:
7.2.2 Defaults Used in XFD Files
ODBC driver for ACUCOBOL-GT data:
2.2.1 Single-tier Components
ODBC driver manager:
2.2.1 Single-tier Components
ODBC.INI configuration file:
3.1 Data Source Names (DSNs)
ODBC:
To add a data source name
1.3 What is ODBC?
1.4 Front- and Back-end ODBC
A.1 ODBC Conformance Levels
8.5 General ODBC Trace Files
ODBC:Acu4GL:
1.4 Front- and Back-end ODBC
ODBC:API:
1.3 What is ODBC?
ODBC:Back end:
1.4 Front- and Back-end ODBC
ODBC:Conformance levels:
A.1 ODBC Conformance Levels
ODBC:Data Source Administrator.:
To add a data source name
ODBC:Front end:
1.4 Front- and Back-end ODBC
ODBC:Overview:
1.3 What is ODBC?
ODBC:Trace files:
8.5 General ODBC Trace Files
ODBC:What is ODBC?:
1.3 What is ODBC?
odbctrac.dll file:
To initiate the Microsoft ODBC trace function
OEM character set:
3.2 Advanced Options
Open Database Connectivity.:
1.3 What is ODBC?
Operators, logical:
6.3.1 SELECT Command
Optimizer, AcuODBC:
6.3.5 The AcuODBC Optimizer
Optimizing:
6.3.5 The AcuODBC Optimizer
Optimizing:Indexes:
6.3.5 The AcuODBC Optimizer
Optimizing:Queries:
6.3.5 The AcuODBC Optimizer
Options, compilation:
3.2 Advanced Options
Options, Debug:
3.4 Vision Options
Options, Debug:Active Transaction:
3.4 Vision Options
Options, Debug:AcuODBC Trace:
3.4 Vision Options
Options, Debug:Vision Trace:
3.4 Vision Options
Options, Vision:
3.4 Vision Options
8.4 AcuODBC Trace Files
Options, Vision:Defining:
3.4 Vision Options
Options, Vision:Trace files:
8.4 AcuODBC Trace Files
Other characters, SQL syntax:
6.3 SQL Syntax Supported by AcuODBC
OTHER clause, WHEN directive:
7.3.9 When Directive
Overview:
6.3.2 INSERT Command
6.3 SQL Syntax Supported by AcuODBC
7.3 Using Directives
6.3.4 UPDATE Command
6.1 Writing Queries
1.1 Overview
2.1 AcuODBC Design
7.1 Data Dictionaries
6.3.3 DELETE Command
To add a data source name
6.3.1 SELECT Command
8.1 Overview of Errors
7.3.9 When Directive
1.3 What is ODBC?
Overview:AcuODBC:
1.1 Overview
Overview:Architecture, AcuODBC:
2.1 AcuODBC Design
Overview:Data dictionaries:
7.1 Data Dictionaries
Overview:DELETE command:
6.3.3 DELETE Command
Overview:Directives, XFD files:
7.3 Using Directives
Overview:Errors:
8.1 Overview of Errors
Overview:INSERT command:
6.3.2 INSERT Command
Overview:ODBC Data Source Administrator:
To add a data source name
Overview:ODBC:
1.3 What is ODBC?
Overview:SELECT command:
6.3.1 SELECT Command
Overview:SQL syntax:
6.3 SQL Syntax Supported by AcuODBC
Overview:UPDATE command:
6.3.4 UPDATE Command
Overview:WHEN directive:
7.3.9 When Directive
Overview:Writing queries:
6.1 Writing Queries

P

Parameters, AcuServer:
3.4 Vision Options
Parameters, AcuServer:Default Timeout:
3.4 Vision Options
Parameters, AcuServer:Server Port:
3.4 Vision Options
Parameters, modifying data source:
To modify data source parameters
Parameters, Transaction:
3.4 Vision Options
Parameters, Transaction:LogBufferSize:
3.4 Vision Options
Parameters, Transaction:LogDevice:
3.4 Vision Options
Parameters, Transaction:LogDir:
3.4 Vision Options
Parameters, Transaction:LogEncryption:
3.4 Vision Options
Parameters, Transaction:LogFile:
3.4 Vision Options
Parameters, Transaction:Logging:
3.4 Vision Options
Parameters, Vision:
3.4 Vision Options
Parameters, Vision:Buffers:
3.4 Vision Options
Parameters, Vision:Defining:
3.4 Vision Options
Parameters, Vision:Locks Per File:
3.4 Vision Options
Parameters, Vision:Max Files:
3.4 Vision Options
Parameters, Vision:Max Locks:
3.4 Vision Options
Password Request, advanced option:
3.2 Advanced Options
Phrases, XFD files:
7.2.2 Defaults Used in XFD Files
Phrases, XFD files:KEY IS:
7.2.2 Defaults Used in XFD Files
Phrases, XFD files:OCCURS clause:
7.2.2 Defaults Used in XFD Files
Phrases, XFD files:REDEFINES clause:
7.2.2 Defaults Used in XFD Files
Phrases:
7.3.9 When Directive
Phrases:FILLER, WHEN directive:
7.3.9 When Directive
Phrases:OTHER, WHEN directive:
7.3.9 When Directive
Phrases:REDEFINES, WHEN directive:
7.3.9 When Directive
Physical Name, File Alias:
3.2 Advanced Options
Pointing to existing DSNs, multi-company files:
To manage multi-company files
Programs, Sample:
4.1 Locating the Sample Program
4.5 Running the Query Sample Program
4.2 The Sample Orders Program
Programs, Sample:Acucorp Orders Program:
4.2 The Sample Orders Program
4.1 Locating the Sample Program
Programs, Sample:Debug Acucorp Orders Program:
4.1 Locating the Sample Program
Programs, Sample:Query Program:
4.5 Running the Query Sample Program
Programs, Sample:Query Sample Program:
4.1 Locating the Sample Program
Programs:
6.2.3 Troubleshooting Your Program
2.1 AcuODBC Design
Programs:Troubleshooting:
6.2.3 Troubleshooting Your Program
Programs:Writing to generate SQL:
2.1 AcuODBC Design

Q

Queries, optimizing:
6.3.5 The AcuODBC Optimizer
Queries, writing:
6.2.1 COBOL vs. Application Language
6.1 Writing Queries
6.2 What To Consider
Queries, writing:COBOL vs application language:
6.2.1 COBOL vs. Application Language
Queries, writing:Considerations:
6.2 What To Consider
Queries, writing:Overview:
6.1 Writing Queries
Query Sample Program:
4.1 Locating the Sample Program
4.5 Running the Query Sample Program

R

Read Only, advanced option:
3.2 Advanced Options
Record and field mapping:
2.2.1 Single-tier Components
7.1 Data Dictionaries
Record definitions, multiple:
7.3.9 When Directive
REDEFINES clause, WHEN directive:
7.3.9 When Directive
REDEFINES clause, XFD files:
7.2.2 Defaults Used in XFD Files
Relational databases:
6.2.2 How Relational Databases Organize Data
Remote directories, data dictionary:
To add a data source name
Remote files, accessing:
2.3 AcuODBC Multiple-Tier
Replacing characters, multi-company files:
To manage multi-company files
Requirements, system:
1.2 Product Requirements
Reserved words, SQL:
6.4 SQL Reserved Words Supported by AcuODBC
Right outer join statement:
6.3.1 SELECT Command

S

Sample Data Source Name, creating:
4.4 The Sample Data Source Name
Sample Programs:
4.1 Locating the Sample Program
4.2 The Sample Orders Program
4.5 Running the Query Sample Program
Sample Programs:Acucorp Orders Program:
4.1 Locating the Sample Program
4.2 The Sample Orders Program
Sample Programs:Debug Acucorp Orders Program:
4.1 Locating the Sample Program
Sample Programs:Query Program:
4.5 Running the Query Sample Program
Sample Programs:Query Sample Program:
4.1 Locating the Sample Program
SELECT command:
6.3 SQL Syntax Supported by AcuODBC
6.3.1 SELECT Command
SELECT command:Overview:
6.3.1 SELECT Command
SELECT command:SQL syntax:
6.3 SQL Syntax Supported by AcuODBC
Server Port, AcuServer parameter:
3.4 Vision Options
Signed Index, advanced option:
3.2 Advanced Options
Single-tier architecture:
2.2.1 Single-tier Components
2.2 AcuODBC Single-Tier
Single-tier architecture:Components:
2.2.1 Single-tier Components
Single-tier architecture:Data dictionary:
2.2.1 Single-tier Components
Single-tier architecture:ODBC driver manager:
2.2.1 Single-tier Components
Single-tier architecture:ODBC driver:
2.2.1 Single-tier Components
Single-tier architecture:Overview:
2.2 AcuODBC Single-Tier
Specifying data dictionary directories:
To add a data source name
Specifying data dictionary directories:Multiple:
To add a data source name
Specifying data dictionary directories:Remote:
To add a data source name
SQL syntax:
6.3.3 DELETE Command
6.3.1 SELECT Command
6.3.4 UPDATE Command
6.3.2 INSERT Command
6.3 SQL Syntax Supported by AcuODBC
SQL syntax:Alphanumeric literals:
6.3 SQL Syntax Supported by AcuODBC
SQL syntax:Brackets:
6.3 SQL Syntax Supported by AcuODBC
SQL syntax:DELETE command:
6.3.3 DELETE Command
6.3 SQL Syntax Supported by AcuODBC
SQL syntax:Ellipses:
6.3 SQL Syntax Supported by AcuODBC
SQL syntax:INSERT command:
6.3 SQL Syntax Supported by AcuODBC
6.3.2 INSERT Command
SQL syntax:Nonnumeric literals:
6.3 SQL Syntax Supported by AcuODBC
SQL syntax:Numeric literals:
6.3 SQL Syntax Supported by AcuODBC
SQL syntax:Other characters:
6.3 SQL Syntax Supported by AcuODBC
SQL syntax:Overview:
6.3 SQL Syntax Supported by AcuODBC
SQL syntax:SELECT command:
6.3 SQL Syntax Supported by AcuODBC
6.3.1 SELECT Command
SQL syntax:UPDATE command:
6.3.4 UPDATE Command
6.3 SQL Syntax Supported by AcuODBC
SQL syntax:Upper case:
6.3 SQL Syntax Supported by AcuODBC
SQL syntax:Vertical bars:
6.3 SQL Syntax Supported by AcuODBC
sql.log file:
To initiate the Microsoft ODBC trace function
SQL:
6.4 SQL Reserved Words Supported by AcuODBC
8.4 AcuODBC Trace Files
A.2 SQL Conformance
2.1 AcuODBC Design
SQL:Conformance Level:
A.2 SQL Conformance
SQL:Generating from Windows applications:
2.1 AcuODBC Design
SQL:Reserved words:
6.4 SQL Reserved Words Supported by AcuODBC
SQL:Trace files:
8.4 AcuODBC Trace Files
Standard Aggregate Functions:
6.3.1 SELECT Command
Starting:
To initiate the Microsoft ODBC trace function
To initiate AcuODBC's Vision or AcuODBC trace function
Starting:AcuODBC trace function:
To initiate AcuODBC's Vision or AcuODBC trace function
Starting:MS trace function:
To initiate the Microsoft ODBC trace function
Statements, Join:
6.3.1 SELECT Command
Statements, Join:Full outer joins:
6.3.1 SELECT Command
Statements, Join:Inner joins:
6.3.1 SELECT Command
Statements, Join:Left outer joins:
6.3.1 SELECT Command
Statements, Join:Right outer joins:
6.3.1 SELECT Command
String Functions:
6.3.1 SELECT Command
Structured Query Language.:
2.1 AcuODBC Design
Summary, dictionary fields:
7.2.3 Summary of Dictionary Fields
Support, technical:
1.5 Technical Support
Supported commands, AcuODBC:
A.1 ODBC Conformance Levels
Syntax, directives and XFD files:
7.3.1 Syntax
Syntax, SQL:
6.3.3 DELETE Command
6.3.1 SELECT Command
6.3 SQL Syntax Supported by AcuODBC
6.3.4 UPDATE Command
6.3.2 INSERT Command
Syntax, SQL:Alphanumeric literals:
6.3 SQL Syntax Supported by AcuODBC
Syntax, SQL:Brackets:
6.3 SQL Syntax Supported by AcuODBC
Syntax, SQL:DELETE command:
6.3 SQL Syntax Supported by AcuODBC
6.3.3 DELETE Command
Syntax, SQL:Ellipses:
6.3 SQL Syntax Supported by AcuODBC
Syntax, SQL:INSERT command:
6.3.2 INSERT Command
6.3 SQL Syntax Supported by AcuODBC
Syntax, SQL:Nonnumeric literals:
6.3 SQL Syntax Supported by AcuODBC
Syntax, SQL:Numeric literals:
6.3 SQL Syntax Supported by AcuODBC
Syntax, SQL:Other characters:
6.3 SQL Syntax Supported by AcuODBC
Syntax, SQL:Overview:
6.3 SQL Syntax Supported by AcuODBC
Syntax, SQL:SELECT command:
6.3 SQL Syntax Supported by AcuODBC
6.3.1 SELECT Command
Syntax, SQL:UPDATE command:
6.3 SQL Syntax Supported by AcuODBC
6.3.4 UPDATE Command
Syntax, SQL:Upper case:
6.3 SQL Syntax Supported by AcuODBC
Syntax, SQL:Vertical bars:
6.3 SQL Syntax Supported by AcuODBC
System DSN:
To add a data source name
System requirements:
1.2 Product Requirements

T

Technical support:
1.5 Technical Support
Trace files:
To initiate the Microsoft ODBC trace function
3.4 Vision Options
8.4 AcuODBC Trace Files
To initiate AcuODBC's Vision or AcuODBC trace function
8.5 General ODBC Trace Files
Trace files:acuodbcn.log:
To initiate AcuODBC's Vision or AcuODBC trace function
3.4 Vision Options
Trace files:Defining:
3.4 Vision Options
Trace files:General:
8.5 General ODBC Trace Files
Trace files:odbctrac.dll:
To initiate the Microsoft ODBC trace function
Trace files:sql.log:
To initiate the Microsoft ODBC trace function
Trace files:Starting AcuODBC trace function:
To initiate AcuODBC's Vision or AcuODBC trace function
Trace files:Starting MS trace function:
To initiate the Microsoft ODBC trace function
Trace files:Troubleshooting:
8.4 AcuODBC Trace Files
8.5 General ODBC Trace Files
Trace files:visionn.log:
To initiate AcuODBC's Vision or AcuODBC trace function
3.4 Vision Options
Transaction Parameters:
3.4 Vision Options
Transaction Parameters:LogBufferSize:
3.4 Vision Options
Transaction Parameters:LogDevice:
3.4 Vision Options
Transaction Parameters:LogDir:
3.4 Vision Options
Transaction Parameters:LogEncryption:
3.4 Vision Options
Transaction Parameters:LogFile:
3.4 Vision Options
Transaction Parameters:Logging:
3.4 Vision Options
Troubleshooting:
8.2 Native Vision Errors
6.2.3 Troubleshooting Your Program
8.1 Overview of Errors
8.4 AcuODBC Trace Files
8.3 Application Errors
8.5 General ODBC Trace Files
Troubleshooting:Application errors:
8.3 Application Errors
Troubleshooting:Errors, overview:
8.1 Overview of Errors
Troubleshooting:Trace files:
8.4 AcuODBC Trace Files
8.5 General ODBC Trace Files
Troubleshooting:Vision errors:
8.2 Native Vision Errors
Troubleshooting:Your program:
6.2.3 Troubleshooting Your Program

U

Unique field names:
7.3.6 Name Directive
Unsigned integers, NUMERIC directive:
7.3.7 Numeric Directive
UPDATE command:
6.3 SQL Syntax Supported by AcuODBC
6.3.4 UPDATE Command
UPDATE command:Overview:
6.3.4 UPDATE Command
UPDATE command:SQL syntax:
6.3 SQL Syntax Supported by AcuODBC
Upper case, SQL syntax:
6.3 SQL Syntax Supported by AcuODBC
USE GROUP directive:
7.3.8 Use Group Directive
7.3.4 Date Directive
User DSN:
To add a data source name

V

Variable, ASSIGN:
7.2.4 Naming the XFD
Vertical bars, SQL syntax:
6.3 SQL Syntax Supported by AcuODBC
Vision parameters:
3.4 Vision Options
Vision parameters:Buffers:
3.4 Vision Options
Vision parameters:Defining:
3.4 Vision Options
Vision parameters:Locks Per File:
3.4 Vision Options
Vision parameters:Max Files:
3.4 Vision Options
Vision parameters:Max Locks:
3.4 Vision Options
Vision Trace Debug Option:
3.4 Vision Options
Vision:
8.4 AcuODBC Trace Files
8.2 Native Vision Errors
3.4 Vision Options
Vision:Errors:
8.2 Native Vision Errors
Vision:Options:
3.4 Vision Options
8.4 AcuODBC Trace Files
Vision:Trace files:
8.4 AcuODBC Trace Files
visionn.log file:
3.4 Vision Options
To initiate AcuODBC's Vision or AcuODBC trace function

W

What is ODBC?:
1.3 What is ODBC?
WHEN directive:
7.3.9 When Directive
WHEN directive:FILLER clause:
7.3.9 When Directive
WHEN directive:NULL values:
7.3.9 When Directive
WHEN directive:OTHER clause:
7.3.9 When Directive
WHEN directive:Overview:
7.3.9 When Directive
WHEN directive:REDEFINES clause:
7.3.9 When Directive
Windows applications, working with:
5.1 Working With Windows Applications
Word 2000 and AcuODBC:
To access data from Word 2000
Word 7.0 and AcuODBC:
To access data from Word for Windows Version 7.0
Words, SQL reserved:
6.4 SQL Reserved Words Supported by AcuODBC
Working with Windows applications:
5.1 Working With Windows Applications
Write Permission, File Alias:
3.2 Advanced Options
Writing programs to generate SQL:
2.1 AcuODBC Design
Writing queries:
6.2 What To Consider
6.1 Writing Queries
6.2.1 COBOL vs. Application Language
Writing queries:COBOL vs application language:
6.2.1 COBOL vs. Application Language
Writing queries:Considerations:
6.2 What To Consider
Writing queries:Overview:
6.1 Writing Queries

X

XFD files:
7.2.2 Defaults Used in XFD Files
7.4 How AcuODBC Locates XFD Files
7.3 Using Directives
7.2 XFD Files
7.2.4 Naming the XFD
XFD files:ASSIGN variable:
7.2.4 Naming the XFD
XFD files:Creating:
7.2 XFD Files
XFD files:Data dictionaries:
7.2 XFD Files
XFD files:Defaults:
7.2.2 Defaults Used in XFD Files
XFD files:Directives:
7.3 Using Directives
XFD files:FILLER data items:
7.2.2 Defaults Used in XFD Files
XFD files:Group items:
7.2.2 Defaults Used in XFD Files
XFD files:Identical field names:
7.2.2 Defaults Used in XFD Files
XFD files:KEY IS phrase:
7.2.2 Defaults Used in XFD Files
XFD files:Locating:
7.4 How AcuODBC Locates XFD Files
XFD files:Mapping fields:
7.2 XFD Files
XFD files:Multiple record definitions:
7.2.2 Defaults Used in XFD Files
XFD files:Naming:
7.2.4 Naming the XFD
XFD files:OCCURS clause:
7.2.2 Defaults Used in XFD Files
XFD files:REDEFINES clause:
7.2.2 Defaults Used in XFD Files