Index

$, directive syntax: 6.3.2 Syntax
*, directive syntax: 6.3.2 Syntax

A

B

C

D

E

editing access records: Modifying access records
editing file aliases: To modify a file alias
editing remote DSNs: To edit a remote data source in Windows
editing remote DSNs:with the AcuODBC Server Data Source Configuration utility: To edit a remote data source in Windows
ellipses, SQL syntax: 5.3 SQL Syntax Supported by AcuODBC
enabling logging: 3.4 Vision Options
enabling logging:transaction support options: 3.4 Vision Options
enabling transaction processing support: 3.4 Vision Options
Encrypt Log File field: 3.4 Vision Options
Encrypt Log File field:transaction Vision tab: 3.4 Vision Options
encrypting log files: 3.4 Vision Options
encrypting XFD files: 6.4 Encrypting XFD Files
errors: 7.1 Overview of Errors 7.3 Application Errors 7.2 Native Vision Errors
errors:application: 7.3 Application Errors
errors:overview: 7.1 Overview of Errors
errors:Vision: 7.2 Native Vision Errors
examples, data dictionary formation: 6.2.3 Examples of Default Mapping
Excel 2000 and AcuODBC: To access data from Excel 2000
Excel 7.0 and AcuODBC: To access data from Excel 97
expressions: 5.3.1 SELECT Command
expressions:arithmetic: 5.3.1 SELECT Command

F

G

General tab (AcuODBC Server Data Source Configuration utility): To configure a remote data source in Windows
General tab (AcuODBC Server Data Source Configuration utility):NT Security field: To configure a remote data source in Windows
General tab: 9.2 Configuring the Remote DSN on the Client 3.2 Defining the Data Source
General tab:Data Directory field: 3.2 Defining the Data Source
General tab:Data File Extension field: 3.2 Defining the Data Source
General tab:Data Source Name field: 3.2 Defining the Data Source
General tab:XFD Directory field: 3.2 Defining the Data Source
general trace files: 7.5 General ODBC Trace Files
generating SQL: 2.1 AcuODBC Design
generating SQL:directly through the Microsoft Jet Database Engine: 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.6 Technical Support
Getting started with AcuODBC Server: 8.2 Getting Started
group items: 6.3.6 DATE Directive 6.2.2 Defaults Used in XFD Files
group items:DATE directive: 6.3.6 DATE Directive
group items:XFD files: 6.2.2 Defaults Used in XFD Files
GUI Dialog field, Advanced tab: 3.3 Advanced Options

H

I

I/O efficiency, USE GROUP directive: 6.3.10 USE GROUP Directive
identical field names, XFD files: 6.2.2 Defaults Used in XFD Files
importing tables in Microsoft Access: To access data from Access 2000
indexed block buffers: 3.4 Vision Options
indexed block buffers:allocating: 3.4 Vision Options
indexes, optimizing: 5.4 The AcuODBC Optimizer
inner join statement: 5.3.2 JOIN Statements
input/output efficiency, USE GROUP directive: 6.3.10 USE GROUP Directive
input: 3.3 Advanced Options
input:alphanumeric: 3.3 Advanced Options
input:numeric: 3.3 Advanced Options
INSERT command: 5.3.3 INSERT Command
INSERT command:linked data: 5.3.3 INSERT Command
installing AcuODBC Server as a service: Installing AcuODBC Server as a Service (Windows Only)
integers, unsigned: 6.3.9 NUMERIC Directive
International Character Handling field: 3.9 Accessing Remote Files
International Character Handling field:AcuServer tab: 3.9 Accessing Remote Files
international character handling: 3.9 Accessing Remote Files
international character handling:default map file: 3.9 Accessing Remote Files
international characters: 3.9 Accessing Remote Files
international characters:mapping: 3.9 Accessing Remote Files
Invalid Numeric Data field, Advanced tab: 3.3 Advanced Options
IP Address field, AcuServer tab: 9.2 Configuring the Remote DSN on the Client
items: 6.2.2 Defaults Used in XFD Files
items:FILLER: 6.2.2 Defaults Used in XFD Files
items:group: 6.2.2 Defaults Used in XFD Files

J

JOIN statements: 5.3.2 JOIN Statements
JOIN statements:inner joins: 5.3.2 JOIN Statements
JOIN statements:left joins: 5.3.2 JOIN Statements
JOIN statements:right joins: 5.3.2 JOIN Statements
JOIN statements:self joins: 5.3.2 JOIN Statements
Julian Base Date field, Advanced tab: 3.3 Advanced Options
Julian base date: 3.3 Advanced Options
Julian base date:specifying: 3.3 Advanced Options
Julian dates, DATE directive: 6.3.6 DATE Directive

K

L

M

maintaining the AcuAccess file: 8.4.1 Maintaining the AcuAccess file
managing drivers, ODBC: 2.2.1 Components
managing multicompany DSNs: 3.8 Multicompany Support
mapping COBOL files to database tables: 3.7 File Aliases
mapping fields: 6.1 Data Dictionaries 2.2.1 Components 6.2 XFD Files
mapping fields:and records: 6.1 Data Dictionaries 2.2.1 Components
mapping fields:XFD files: 6.2 XFD Files
mapping international characters: 3.9 Accessing Remote Files
master data source: 3.8.2 Creating Individual Company-specific DSNs
master data source:specifying: 3.8.2 Creating Individual Company-specific DSNs
master DSN: To modify company information 3.8.1 Creating the Master DSN
master DSN:creating for multicompany DSNs: 3.8.1 Creating the Master DSN
master DSN:deleting individual companies: To modify company information
Max Files Vision parameter, defining: 3.4 Vision Options
Max Locks Vision parameter, defining: 3.4 Vision Options
mixed character type: 3.3 Advanced Options
modifying access records: Modifying access records
modifying data source parameters: To modify data source parameters
modifying file aliases: To modify a file alias
modifying the AcuAccess file: 8.4.2 Modifying the Server Access File
MS ODBC: 2.2.1 Components
MS Query, generating SQL: 2.1 AcuODBC Design
multicompany DSNs: 3.8.1 Creating the Master DSN 3.8 Multicompany Support
multicompany DSNs:creating master DSN: 3.8.1 Creating the Master DSN
multicompany DSNs:managing: 3.8 Multicompany Support
multicompany DSNs:specifying data source name: 3.8.1 Creating the Master DSN
multicompany DSNs:specifying location of XFD directory: 3.8.1 Creating the Master DSN
multicompany support: 3.8 Multicompany Support To modify company information
multicompany support:and Microsoft Access: 3.8 Multicompany Support
multicompany support:deleting components of master DSN: To modify company information
multicompany support:modifying information: To modify company information
Multicompany tab: 3.8.1 Creating the Master DSN 3.8 Multicompany Support 3.8.2 Creating Individual Company-specific DSNs
Multicompany tab:AcuODBC configuration: 3.8 Multicompany Support
Multicompany tab:Company field: 3.8.1 Creating the Master DSN
Multicompany tab:Data Directory field: 3.8.1 Creating the Master DSN
Multicompany tab:specifying master data source: 3.8.2 Creating Individual Company-specific DSNs
Multicompany tab:Write Permission field: 3.8.1 Creating the Master DSN
multiple record definitions: 6.2.2 Defaults Used in XFD Files 6.3.11 WHEN Directive
multiple trace files: 3.5 Tracing Options

N

O

P

Q

R

S

T

Table Name Cache File field: 3.3 Advanced Options
Table Name Cache File field:Advanced tab: 3.3 Advanced Options
Table Name field, File Alias tab: 3.7 File Aliases
table names: 3.1 Data Source Names (DSNs) 3.7 File Aliases 5.3 SQL Syntax Supported by AcuODBC
table names:hyphens in: 3.1 Data Source Names (DSNs) 5.3 SQL Syntax Supported by AcuODBC
table names:specifying on File Alias tab: 3.7 File Aliases
table names:underscores in: 3.1 Data Source Names (DSNs) 5.3 SQL Syntax Supported by AcuODBC
tables, linking: 3.8 Multicompany Support
tables, linking:multicompany support and Microsoft Access: 3.8 Multicompany Support
tables, open: 3.3 Advanced Options
tables, SQL: 3.2 Defining the Data Source
tables, SQL:naming: 3.2 Defining the Data Source
tables: To access data from Access 2000
tables:linking versus importing in Microsoft Access: To access data from Access 2000
technical support: 1.6 Technical Support
Temp File Directory field, Vision tab: 3.4 Vision Options
Temp file directory: 3.4 Vision Options
Temp file directory:specifying name: 3.4 Vision Options
temporary files: 3.4 Vision Options
temporary files:specifying location: 3.4 Vision Options
timestamp literals, SQL syntax: 5.3 SQL Syntax Supported by AcuODBC
trace files: To start AcuODBC's trace functions 7.5 General ODBC Trace Files 3.5 Tracing Options 7.4 AcuODBC Trace Files To start the Microsoft ODBC trace function
trace files:acuodbc_trace.log: To start AcuODBC's trace functions 3.5 Tracing Options
trace files:general: 7.5 General ODBC Trace Files
trace files:naming: 3.5 Tracing Options
trace files:odbctrac.dll: To start the Microsoft ODBC trace function
trace files:sql.log: To start the Microsoft ODBC trace function
trace files:sql_trace.log: 3.5 Tracing Options
trace files:starting AcuODBC trace function: To start AcuODBC's trace functions
trace files:starting MS trace function: To start the Microsoft ODBC trace function
trace files:troubleshooting: 7.4 AcuODBC Trace Files 7.5 General ODBC Trace Files
trace files:vision_trace.log: To start AcuODBC's trace functions 3.5 Tracing Options
Tracing tab, AcuODBC Configuration property sheet: 3.5 Tracing Options
transaction log file: 3.4 Vision Options
transaction log file:buffer size in bytes: 3.4 Vision Options
transaction parameters: 3.4 Vision Options
transaction parameters:Log Buffer Size: 3.4 Vision Options
transaction processing support: 3.4 Vision Options
transaction processing support:enabling: 3.4 Vision Options
Transaction Support Options fields: 3.4 Vision Options
Transaction Support Options fields:Vision tab: 3.4 Vision Options
transaction support options: 3.4 Vision Options
transaction support options:enabling transaction processing support: 3.4 Vision Options
transaction support options:Encrypt Log File field: 3.4 Vision Options
transaction support options:Log File field: 3.4 Vision Options
transaction support options:Log to Device field: 3.4 Vision Options
transaction support options:logging: 3.4 Vision Options
troubleshooting: 7.2 Native Vision Errors 7.5 General ODBC Trace Files 7.1 Overview of Errors 7.4 AcuODBC Trace Files 3.5 Tracing Options 7.3 Application Errors
troubleshooting:application errors: 7.3 Application Errors
troubleshooting:errors, overview: 7.1 Overview of Errors
troubleshooting:trace files: 7.4 AcuODBC Trace Files 7.5 General ODBC Trace Files
troubleshooting:Vision errors: 7.2 Native Vision Errors
two-tier architecture: 2.4.1 Components 2.4 Remote SQL Processing
two-tier architecture:components: 2.4.1 Components
two-tier architecture:overview: 2.4 Remote SQL Processing
two-tier environment: 8.1 AcuODBC Server
two-tier environment:advantages: 8.1 AcuODBC Server

U

V

VARCHAR character type: 3.3 Advanced Options
variable, ASSIGN: 6.2.5 Naming the XFD File
version: 8.5.8 acuodbcs -version
version:displaying acuodbcs release version: 8.5.8 acuodbcs -version
viewing license messages: 3.3 Advanced Options
Vision files: 3.4 Vision Options
Vision files:defining options: 3.4 Vision Options
Vision parameters: 3.4 Vision Options
Vision parameters:Buffers: 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 tab: 3.4 Vision Options
Vision tab:AcuODBC Configuration property sheet: 3.4 Vision Options
Vision tab:Transaction Support Options fields: 3.4 Vision Options
Vision tracing debug option: 3.5 Tracing Options
Vision: 7.4 AcuODBC Trace Files 7.2 Native Vision Errors
Vision:errors: 7.2 Native Vision Errors
Vision:options: 7.4 AcuODBC Trace Files
Vision:trace files: 7.4 AcuODBC Trace Files
vision_trace.log file: To start AcuODBC's trace functions 3.5 Tracing Options

W

WHEN directive: 6.3.11 WHEN Directive
WHEN directive:FILLER clause: 6.3.11 WHEN Directive
WHEN directive:NULL values: 6.3.11 WHEN Directive
WHEN directive:OTHER clause: 6.3.11 WHEN Directive
WHEN directive:overview: 6.3.11 WHEN Directive
WHEN directive:REDEFINES clause: 6.3.11 WHEN Directive
WHERE clause: 5.3.4 UPDATE Command 5.3.5 DELETE Command 5.3.1 SELECT Command
WHERE clause:DELETE command: 5.3.5 DELETE Command
WHERE clause:SELECT command: 5.3.1 SELECT Command
WHERE clause:UPDATE command: 5.3.4 UPDATE Command
WHERE constraint: 5.3.4 UPDATE Command 5.3.1 SELECT Command 5.3.5 DELETE Command
wildcards in access records: 8.4.2 Modifying the Server Access File
windows applications, working with: 4.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 97
words, SQL reserved: 5.5 SQL Reserved Words Recognized by AcuODBC
working with Windows applications: 4.1 Working With Windows Applications
writable data sources and non-numeric data in numeric fields: 3.3 Advanced Options
Write Permission field: 3.7 File Aliases 3.8.1 Creating the Master DSN
Write Permission field:File Alias tab: 3.7 File Aliases
Write Permission field:Multicompany tab: 3.8.1 Creating the Master DSN
write permission: 3.7 File Aliases 3.8.1 Creating the Master DSN 3.3 Advanced Options 6.3.4 AcuODBC READ-ONLY Directive
write permission:AcuODBC READ-ONLY directive: 6.3.4 AcuODBC READ-ONLY Directive
write permission:Advanced tab: 3.3 Advanced Options
write permission:file aliases: 3.7 File Aliases
write permission:Multicompany tab: 3.8.1 Creating the Master DSN
write permission:overriding DSN default: 3.7 File Aliases
write permission:overriding master DSN defaults: 3.8.1 Creating the Master DSN
write permissions: 3.8.1 Creating the Master DSN 3.7 File Aliases 6.3.4 AcuODBC READ-ONLY Directive
write permissions:overriding default DSN: 3.7 File Aliases
write permissions:overriding default: 6.3.4 AcuODBC READ-ONLY Directive
write permissions:overriding master DSN default: 3.8.1 Creating the Master DSN
writing programs to generate SQL: 2.1 AcuODBC Design
writing queries: 5.2 What to Consider 5.2.1 COBOL vs. Application Language 5.1 Writing Queries to Access Data
writing queries:COBOL vs application language: 5.2.1 COBOL vs. Application Language
writing queries:considerations: 5.2 What to Consider
writing queries:overview: 5.1 Writing Queries to Access Data
writing SQL directly: 2.1 AcuODBC Design

X