contents.gif

Index

index_a.gifindex_b.gifindex_c.gifindex_d.gifindex_e.gifindex_f.gifindex_g.gifindex_h.gifindex_i.gifindex_j.gifindex_k.gifindex_l.gifindex_m.gifindex_n.gifindex_o.gifindex_p.gifindex_r.gifindex_s.gifindex_t.gifindex_u.gifindex_v.gifindex_w.gifindex_x.gifindex_y.gif
$ in Indicator Area
Syntax
4GL-2000-CUTOFF
Runtime Configuration Variables
4GL-8-DIGIT-CUTOFF
Runtime Configuration Variables
4GL-COLUMN-CASE
Runtime Configuration Variables
4GL-IGNORED-SUFFIX-LIST
DBMaker

Microsoft SQL Server
ODBC
Sybase
4GL-ILLEGAL-DATA
Runtime Configuration Variables
4GL-JULIAN-BASE-DATE
Runtime Configuration Variables

A

A4GL-COMMIT-COUNT
DBMaker

ODBC
A4GL-MAX-DATE
Runtime Configuration Variables
A4GL-MIN-DATE
Runtime Configuration Variables
A-MSSQL-MAX-CHAR-LENGTH
MSSQL Configuration Variables
Accessing a Database
Steps to Follow
Accessing Data
Accessing Data
Acu4GL
ACUCOBOL-GT Plug-in
Acu4GL Cursor
Oracle
Acu4GL for DBMaker Information
Acu4GL for DBMaker Information
Acu4GL: Data Dictionaries
Data Dictionaries and Acu4GL
Acu4GL:Data Dictionaries and Mapping
Data Dictionaries and Mapping
Acu4GL:Database Concepts
Database Concepts
Acu4GL:How it works
How Acu4GL Works
Acu4GL for Informix Information
Acu4GL for Informix Information
Acu4GL:Steps to Follow
Steps to follow
Acu4GL:Summary
Summary
Acu4GL and Version Compatibility
Acu4GL Overview
ACUCOBOL-GT: lock table missing
MSSQL
ACUCOBOL-GT: plug-in
XFD Location
Acucorp
Technical Support
acuorders table
XFD Location
A-DBM-COMMIT-ON-BEGIN:DBMaker
DBMaker: Configuration File Variables
A-DBM-DATABASE:DBMaker
DBMaker: Configuration File Variables
A-DBM-ERROR-MAP-FILE:DBMaker
DBMaker: Configuration File Variables
A-DBM-LOCK-METHOD:DBMaker
DBMaker: Record Locking
DBMaker: Configuration File Variables
A-DBM-LOGIN:DBMaker
DBMaker: Configuration File Variables
A-DBM-PASSWD:DBMaker
DBMaker: Configuration File Variables
A-INFORMIX-ERROR-FILE
A-INFORMIX-ERROR-FILE
Alpha Directive
Alpha Directive
Altering a user session
Informix
Alternate REWRITE method
MSSQL
Sybase
A-MSSQL-ADD-IDENTITY

A-MSSQL-DATABASE
A-MSSQL-DEFAULT-CONNECTION
A-MSSQL-EXTRA-PROC
A-MSSQL-FAST-ACCESS
A-MSSQL-FORCED-INDEX
A-MSSQL-LOCK-DB
A-MSSQL-LOGIN
A-MSSQL-MAX-COLUMNS
A-MSSQL-NATIVE-LOCK-TIMEOUT
A-MSSQL-NO-23-ON-START
A-MSSQL-PASSWD
A-MSSQL-ROWCOUNT
A-MSSQL-SKIP-ALTERNATE-KEYS
A-MSSQL-USE-DROPDOWN-QUERIES
A-MSSQL-VISION-LOCKS-FILE
ANSI-compliant directive
         Syntax
A-ODBC-COMMIT-ON-BEGIN

A-ODBC-DATASOURCE
A-ODBC-ERROR-MAP-FILE
A-ODBC-LOCK-METHOD
A-ODBC-LOGIN
A-ODBC-PASSWD
A-ODBC-PRINT-LOG
A-ODBC-QUOTE-IDENTIFIERS
A-ODBC-UNSIGNED- TINYINT
A-ODBC-USE-CHAR-FOR-BINARY
A-ODBC-USE-SPACE-IN-DATES
A-ORACLE-ERROR-FILE
A-ORA-HINTS
Assign
Assign name
A-SYB-ADD-IDENTITY
A-SYB-ADD-TIMESTAMP
A-SYB-DATABASE
A-SYB-DEFAULT-CONNECTION
A-SYB-EXTRA-PROC
A-SYB-FAST-ACCESS
A-SYB-FORCED-INDEX
A-SYB-LOCK-DB
A-SYB-LOGIN
A-SYB-MAX-CHARACTERS
A-SYB-MAX-COLUMNS
A-SYB-NATIVE-LOCK-TIMEOUT
A-SYB-NO-23-ON-START
A-SYB-PASSWD
A-SYB-ROWCOUNT
A-SYB-SKIP-ALTERNATE-KEYS
A-SYB-USE-DROPDOWN-QUERIES
A-SYB-VISION-LOCKS-FILE
Attempt to use multiple users: Oracle
 
 

B

Binary Directive
Binary Directive
Binary Large Objects:DBMaker
DBMaker Concepts Overview
BINARY numbers
Illegal COBOL Data
Btrieve
Accessing Data

C

C$RERR
DBMaker: Retrieving errors
Informix: Retrieving Errors
Microsoft SQL Server: Retrieving Errors
ODBC: Retrieving Errors
Oracle: Retrieving Errors
Sybase: Retrieving Errors
Cache error
Microsoft SQL Server
Sybase
Calling sql.acu from a Program
To call sql.acu from a program
Check filetbl.c: DBMaker
DBMaker: Windows 95/NT Installation Steps for the Acu4GL for DBMaker Interface
C-ISAM
Accessing Data
COBOL
Examples of working with
Invalid Data items
I/O
modifying procedures
records: formation
column
column of a key: Microsoft SQL Server
column of a key: Sybase
COBOL Program: Preparing and Compiling
Preparing and Compiling your COBOL program
Comment Directive
Comment Directive
COMMIT WORK:
Oracle: Handling Transactions
COMMIT-COUNT
Oracle: Handling Transactions
Common Questions and Answers: DBMaker
DBMaker: Common Questions and Answers
Common Questions and Answers: Informix
Informix: Common Questions and Answers
Common Questions and Answers: Microsoft SQL Server
Microsoft SQL Server: Common Questions and Answers
Common Questions and Answers: ODBC
ODBC: Common Questions and Answers
Common Questions and Answers: Oracle
Oracle: Common Questions and Answers
Common Questions and Answers: Sybase
Sybase: Common Questions and Answers
Compiler and Runtime Options
Compiler and Runtime Options
Compiler Options
Compiler and Runtime Options
Compiler Options
Compile-time Errors
Compile-time Errors
Compile-time Warning
Compile-time Warning
Compiling: Preparing the COBOL Program
Preparing and Compiling your COBOL program
Configuration File Variables: DBMaker
DBMaker: Configuration File Variables
Configuration File Variables: Informix
Informix: Configuration File Variables
Configuration File Variables: Microsoft SQL Server
Microsoft SQL Server: Configuration File Variables
Configuration File Variables: ODBC
ODBC: Configuration File Variables
Configuration File Variables: Oracle
Oracle: Configuration File Variables
Configuration File Variables:Sybase
Sybase: Configuration File Variables
Configured login:DBMaker
DBMaker: Setting Up a User Account
Copy runcbl to the correct directory:DBMaker
DBMaker: UNIX Installation Steps for the Acu4GL for DBMaker Interface
Copy runtime to directory: DBMaker
DBMaker: Windows 95/NT Installation Steps for the Acu4GL for DBMaker Interface
Corrupt dictionary file: DBMaker
DBMaker: Runtime Errors
Create a new runtime: DBMaker
DBMaker: UNIX Installation Steps for the Acu4GL for DBMaker Interface
Cursor Caching
Oracle: Checking System Parameters
Cursors
Oracle: Checking System Parameters

D

Data
searches
Sources: ODBC
Data Dictionaries
Data Dictionaries
Data Dictionaries and Acu4GL
creating
Data Dictionaries and Mapping
Data Dictionaries and Mapping
Database
Administrator
Microsoft SQL Server
Database Concepts
Database Concepts
Database Data: Invalid
Invalid Database Data
Database table: How it is Formed
Understanding how the database table is formed
Database Table: Informix
Informix: Using the Database Table
Database Table: Microsoft SQL Server
Microsoft SQL Server: Using the Database Table
Database Table: Oracle
Oracle: Using the Database Table
Date
DATE
Date Directive
Date Directive
DBM: Designating the Host File System
DBMaker: Designating the Host File System
DBMaker and Acu4GL Architecture
DBMaker and Acu4GL Architecture
DBMaker Concepts Overview
DBMaker Concepts Overview
DBMaker Data Types
DBMaker: Data Type Mapping
DBMaker Information
Acu4GL for DBMaker Information
DBMaker library function returned an unexpected
DBMaker: Runtime Errors
DBMaker Structure
DBMaker Structure
dbmaker.err: DBMaker
DBMaker: Configuration File Variables
DBMaker: Common Questions and Answers
DBMaker: Common Questions and Answers
DBMaker: Configuration File Variables
DBMaker: Configuration File Variables
DBMaker: Contents of the Medium
DBMaker: Windows 95/NT Installation Steps for the Acu4GL for DBMaker Interface
DBMaker: UNIX Installation Steps for the Acu4GL for DBMaker Interface
DBMaker: Data Type Mapping
DBMaker: Data Type Mapping
DBMaker: Designating the Host Database
DBMaker: Designating the Host Database
DBMaker: Designating the Host File System
DBMaker: Designating the Host File System
DBMaker: Error Messages
DBMaker: Troubleshooting
DBMaker: Error Retrieval
DBMaker: Retrieving errors
DBMaker: Installation and Setup for Windows 95/NT and UNIX
DBMaker: Installation and Setup for Windows 95/NT and UNIX
DBMaker: Installation Overview
DBMaker: Installation Overview
DBMaker: Installing the UNIX Product
DBMaker: UNIX Installation Steps for the Acu4GL for DBMaker Interface
DBMaker: Limits and Ranges
DBMaker: Limits and Ranges
DBMaker: Mapping COBOL Data Types to DBMaker Data Types
DBMaker: Data Type Mapping
DBMaker: Mapping DBMaker Data Types to COBOL Data Types
DBMaker: Data Type Mapping
DBMaker: Native SQL Errors
DBMaker: Native SQL Errors
DBMaker: Record Locking
DBMaker: Record Locking
DBMaker: Relinking Steps
DBMaker: Windows 95/NT Installation Steps for the Acu4GL for DBMaker Interface
DBMaker: Retrieving errors
DBMaker: Retrieving errors
DBMaker: Runtime Configuration Files
DBMaker: Configuration File Variables
DBMaker: Runtime Errors
DBMaker: Runtime Errors
DBMaker: Setting Up a User Account
DBMaker: Setting Up a User Account
DBMaker: Setting Up Data Sources
DBMaker: Installation Overview
DBMaker: Technical Information, Troubleshooting, and Common Questions and Answers
DBMaker: Technical Information, Troubleshooting, and Common Questions and Answers
DBMaker: Technical Specifications
DBMaker: Technical Information, Troubleshooting, and Common Questions and Answers
DBMaker: Troubleshooting
DBMaker: Troubleshooting
DBMaker: UNIX Installation Steps for the Acu4GL for DBMaker Interface
DBMaker: UNIX Installation Steps for the Acu4GL for DBMaker Interface
DBMaker: Windows 95/NT Installation Steps
DBMaker: Windows 95/NT Installation Steps for the Acu4GL for DBMaker Interface
DBMaker: Windows 95/NT Installation Steps for the Acu4GL for DBMaker Interface
DBMaker: Windows 95/NT Installation Steps for the Acu4GL for DBMaker Interface
DBMaker:Acu4GL architecture
DBMaker and Acu4GL Architecture
DBMaker:Application Program Interface (API)
DBMaker Structure
DBMaker: Binary Large Objects
DBMaker Concepts Overview
DBMaker: client/server model
DBMaker Structure
DBMaker: data sharing between tables
DBMaker: Common Questions and Answers
DBMaker:Database communication and control area
DBMaker Structure
DBMaker: Database designation
DBMaker: Designating the Host Database
DBMaker: defined
DBMaker Concepts Overview
DBMaker: dmapi.lib
DBMaker Structure
DBMaker: dmserver
DBMaker Structure
DBMaker: dmSQL
DBMaker: UNIX Installation Steps for the Acu4GL for DBMaker Interface
DBMaker: dmsqlc
DBMaker Structure
DBMaker: error messages
DBMaker: Common Questions and Answers
DBMaker: File Objects
DBMaker Concepts Overview
DBMaker: files for linking to C routines
DBMaker: Common Questions and Answers
DBMaker: keys retrieval order
DBMaker: Common Questions and Answers
DBMaker: libmapic.a
DBMaker Structure
DBMaker: login problems
DBMaker: Common Questions and Answers
DBMaker: perfomance degradation
DBMaker: Common Questions and Answers
DBMaker: platform requirements
DBMaker: Installation Overview
DBMaker: single-user model
DBMaker Structure
DBMaker: SQL Engine
DBMaker Structure
DBMaker: System control area
DBMaker Structure
DBMaker: Troubleshooting
DBMaker: Troubleshooting
DBMaker: Vision
DBMaker: Common Questions and Answers
DBMaker: Vision file problem
DBMaker: Common Questions and Answers
DBMaker: XFD files
DBMaker: Common Questions and Answers
Default Behavior
Default Behavior
DEFAULT-HOST
Informix: Designating a database
Defaults Used in XFD files
Defaults used in XFD files
Demo Program
The Demonstration Program
demo.cbl
The Demonstration Program
Designating the Host Database: DBMaker
DBMaker: Designating the Host Database
Dictionary (.xfd) file not found
DBMaker: Runtime Errors
Informix: Runtime Errors
ODBC: Runtime Errors
Oracle: Runtime Errors
Microsoft SQL Server: Runtime Errors
Sybase: Runtime Errors
Dictionary Fields
Summary of dictionary fields
Directive Syntax
Syntax
Directives: Using
Using Directives
dmSQL:DBMaker
DBMaker: UNIX Installation Steps for the Acu4GL for DBMaker Interface
Document Overview
Document Overview
Driver Manager: ODBC
ODBC: Designating the Host Data Source

E

E.F. Codd
Edit filetbl.c: DBMaker
DBMaker: UNIX Installation Steps for the Acu4GL for DBMaker Interface
E-mail addresses
Technical Support
Error Messages
DBMaker: Troubleshooting
Informix: Troubleshooting
Microsoft SQL Server: Troubleshooting
ODBC: Troubleshooting
Oracle: Runtime Errors
Sybase: Troubleshooting
Error Retrieval
Microsoft SQL Server: Retrieving errors
DBMaker: Retrieving errors
Informix: Retrieving Errors
Microsoft SQL Server: Retrieving errors
ODBC: Retrieving errors
Oracle: Retrieving Errors
Sybase: Retrieving Errors
Examples of XFD Names
Examples of XFD names
Execute the Batch File
Microsoft SQL Server
Execute the Script
Oracle
Execution Path: Oracle
Oracle: Setting Up the User Environment
Existing Data
New and Existing Database Files
Existing Database Files
Existing Database Files
External variable
declaring

F

Fax numbers
Technical Support
Field
Understanding How the Database Table is Formed
Field Names
Field names
Field Names: Identical
Identical field names
Field Names: Long
Long field names
Field Names: Name Conflict Resolution
Field names
Field Names longer than 18 characters
Preparing and Compiling your COBOL program
Field with identical names
Identical Field Names
FILE
Naming the XFD
FILE CONTROL
Understanding How the Database Table is Formed
File Directive
File Directive
File Objects: DBMaker
DBMaker Concepts Overview
File Search Path: Oracle
Oracle: Setting Up the Search Path
filename-HOST
Runtime Configuration Variables
Filler
Name Directive
Defaults used in XFD files
When Directive
Finderr
Informix
Forming the final XFD name
Naming the XFD

G

Generic File Handler
Accessing Data
Getting Started
Getting Started
Getting Started: Informix
DBMaker: Installation and Setup for Windows 95/98/NT and UNIX
Informix: Getting Started
Microsoft SQL Server: Getting Started
ODBC: Installation and Setup
Oracle: Installation and Setup
Sybase: Getting Started
GRANT ALL PRIVILEGES
Running sql.acu from the Command Line
Group
Defaults used in XFD files
Growth planning
Guidelines
Guidelines for perfomance
Guidelines

H

Handling invalid dates
How Acu4GL Works
Help menu
How Acu4GL Works
HIGH VALUES
How Acu4GL Works
HOST
How Acu4GL Works
How Acu4GL Works
How Acu4GL Works
How Do I Match Existing Numeric Fields?
How do I match existing numeric fields?
How Do I Match Existing Text Fields?
How do I match existing text fields?
How to compile a COBOL program
The Demonstration Program
How to map RDBMS data types
The Demonstration Program
How to modify records
The Demonstration Program
How to Use the On-line Document
Overview
Hyphens
Defaults Used in XFD Files

I

I/O Efficiency
Steps to Follow
Use Group Directive
Identical Field Names
Identical field names
Illegal COBOL Data
Illegal COBOL Data
Illegal size or type of data for variable xxx:DBMaker
DBMaker: Runtime Errors
ODBC: Runtime Errors
Indicator area
Secondary-Table Directive
Inf_inst
Informix: Installing the Product
INF-LOGIN
Informix: Configuration File Variables
Informix 7.x Performance
Informix 7.x Performance
Informix Information
Informix Information
Informix: Common Questions and Answers
Informix: Common Questions and Answers
Informix: Configuration File Variables
Informix: Configuration File Variables
Informix: Database Table
Informix: Using the Database Table
Informix: DEFAULT-HOST
Informix: Designating a database
Informix: Designating a Database
Informix: Designating a database
Informix: Error Messages
Informix: Troubleshooting
Informix: Error Retrieval
Informix: Retrieving Errors
Informix: FILE TRACE
Informix: Retrieving Errors
Informix: Getting Started
Informix: Getting Started
Informix: INF-LOGIN
Informix: Configuration File Variables
Informix: Information
Informix Information
Informix: INF-PASSWD
Informix: Configuration File Variables
Informix: Installation
Informix: Installation
Informix: Installing the Product
Informix: Installing the Product
Informix: ISAM Error
Informix: Retrieving Errors
Informix: Limits and Ranges
Informix: Limits and Ranges
Informix: Retrieving Errors
Informix: Retrieving Errors
Informix: Runtime Configuration Files
Informix: Configuration File Variables
Informix: Runtime Errors
Informix: Runtime Errors
Informix: Supported Features
Informix: Supported Features
Informix: Switching File Systems
Informix: Switching File Systems
Informix: Technical Tips
Informix: Technical Tips
Informix: Transaction Logging
Informix: Common Questions and Answers
Informix: Using the Database Table
Informix: Using the Database Table
Informix:Contents of the Medium
Informix: Contents of the Medium
Informix:Troubleshooting
Informix: Troubleshooting
INF-PASSWD
Informix: Configuration File Variables
Installation and Setup: Oracle
Oracle: Installation and Setup
Installation Information
Installation
Installation: Acu4GL for DBMaker for Windows 95/NT
DBMaker: Windows 95/NT Installation Steps for the Acu4GL for DBMaker Interface
Installation: DBMaker
DBMaker: Installation Overview
Installation: Informix
Informix: Installation
Installation: Microsoft SQL Server
Microsoft SQL Server: Installation
Installation: ODBC
ODBC: Installation
ODBC: Installation steps
Installation: Sybase
Sybase: Acu4GL Installation
Installation: DBMaker
DBMaker: UNIX Installation Steps for the Acu4GL for DBMaker Interface
Installation: Oracle
Oracle: Installation
Install the ACUCOBOL-GT stored procedures
Microsoft SQL Server: Installation steps on a Windows NT server machine

Sybase: Installation steps on the UNIX server
Sybase: Installation steps for a Windows NT server machine - UNIX Client
Sybase: Installation steps on the UNIX server machine
Sybase: Installation steps on a Windows NT server machine - Windows 95/98/NT Client
Installing the Product: Oracle: SCO UNIX
Oracle: Installing the Product
Installing the UNIX Product: DBMaker
DBMaker: UNIX Installation Steps for the Acu4GL for DBMaker Interface
Interface Routines
Interface routines
Invalid Column Name OR Reserved Word:DBMaker
DBMaker: Native SQL Errors
ODBC: Native SQL Errors
Invalid Data
Invalid Data
Invalid Data Other than Keys
Invalid data other than keys
Invalid Database Data
Invalid Database Data
Invalid Key Data
Invalid key data
ISAM Error: Informix
Informix: Retrieving Errors

J

Julian Base Date
Runtime Configuration Variables
Julian Date Calculations
Runtime Configuration Variables

K

Key: null
Invalid key data
Key Data: Invalid
Invalid key data
Key Fields
Defaults used in XFD files
KEY IS
Understanding How the Database Table is Formed
KEY IS PHRASE
Defaults Used in XFD Files

L

Limits and Ranges: DBMaker
DBMaker: Limits and Ranges
Limits and Ranges: Informix
Informix: Limits and Ranges
Limits and Ranges: Microsoft SQL Server
Microsoft SQL Server: Limits and Ranges
Limits and Ranges: ODBC
ODBC: Limits and Ranges
Limits and Ranges: Oracle
Oracle: Limits and Ranges
Limits and Ranges: Sybase
Sybase: Limits and Ranges
Link the runtime system: DBMaker
DBMaker: UNIX Installation Steps for the Acu4GL for DBMaker Interface
DBMaker: Windows 95/NT Installation Steps for the Acu4GL for DBMaker Interface
Linking: DBMaker
DBMaker: Windows 95/NT Installation Steps for the Acu4GL for DBMaker Interface
Linking: Informix
Informix: Installing the Product
Linking: Microsoft SQL Server - Windows Client Machine
Microsoft SQL Server: Installation steps for a Windows 95/98/NT client
Linking: Microsoft SQL ServerWindows 95 or Windows NT Client Machine
Microsoft SQL Server: Installation steps for a Windows 95 or Windows NT client
Linking: ODBC
ODBC: Relinking steps
Linking: Oracle
Oracle: Installing the Product
Linking: Sybase - UNIX client
Sybase: Installation steps on the UNIX client
Linking: Sybase - Windows 95/98/NT Client Machine
Sybase: Installation steps for a Windows 95/98/NT client
Linking: Sybase - Windows 95 or Windows NT Client Machine
Sybase: Installation steps for a Windows 95 or Windows NT client
Long Field Names
Long field names

M

Makefile.inf
Informix: Installing the Product
Map File: DBMaker
DBMaker: Configuration File Variables
Mapping DBMaker Data Types
DBMaker: Data Type Mapping
Mapping ODBC Data Types
ODBC: Mapping COBOL Data Types to ODBC Data Types
Mapping: XFD
Naming the XFD
Matching Exisiting Text Fields
How do I match existing text fields?
Matching Numeric Fields
How do I match existing numeric fields?
MAX-CURSORS
Informix: Configuration File Variables
Oracle: Checking System Parameters
Oracle: Configuration File Variables
Microsoft Access
ODBC Structure
Microsoft SQL Server
Microsoft SQL Server: Retrieving errors
Microsoft SQL Server Concepts Overview
Microsoft SQL Server Concepts Overview
Microsoft SQL Server Information
Microsoft SQL Server Information
Microsoft SQL Server: Common Answers and Questions
Microsoft SQL Server: Common Questions and Answers
Microsoft SQL Server: Configuration File Variables
Microsoft SQL Server: Configuration File Variables
Microsoft SQL Server: Contents of the Medium
Microsoft SQL Server: Contents of the medium
Microsoft SQL Server: Designating the Host File System
Microsoft SQL Server: Designating the Host File System
Microsoft SQL Server: Error Messages
Microsoft SQL Server: Troubleshooting
Microsoft SQL Server: Getting Started
Microsoft SQL Server: Getting Started
Microsoft SQL Server: Installation
Microsoft SQL Server: Installation
Microsoft SQL Server: Installation Steps for a Windows 95 or Windows NT Client
Microsoft SQL Server: Installation steps for a Windows 95 or Windows NT client
Microsoft SQL Server: Installation Steps on a Windows Client Machine
Microsoft SQL Server: Installation steps on a Windows client machine
Microsoft SQL Server: Installing the Acu4GL Product
Microsoft SQL Server: Installing the Acu4GL Product
Microsoft SQL Server: Installing the Diskette on the Client Machine
Microsoft SQL Server: Installing the diskette on the client machine
Microsoft SQL Server: Installing the Interface for Use with a Windows/Windows 95/Windows NT Client and a Windows NT Server
Microsoft SQL Server: Installing the Interface for use with a Windows/Windows 95/Windows NT Client and a Windows NT Server
Microsoft SQL Server: Limits and Ranges
Microsoft SQL Server: Limits and Ranges
Microsoft SQL Server: Retrieving Errors
Microsoft SQL Server: Retrieving errors
Microsoft SQL Server: Runtime Configuration Files
Microsoft SQL Server: Configuration File Variables
Microsoft SQL Server: Runtime Errors
Microsoft SQL Server: Runtime Errors
Microsoft SQL Server: Setting Up a User Account
Microsoft SQL Server: Setting Up a User Account
Microsoft SQL Server: Setting Up the User Environment
Microsoft SQL Server: Setting Up the User Environment;Setting Up the User Environment: Microsoft SQL Server
Microsoft SQL Server: Technical Specifications
Microsoft SQL Server: Technical Specifications
Microsoft SQL Server: Troubleshooting
Microsoft SQL Server: Troubleshooting
Microsoft SQL Server: Using the Database Table
Microsoft SQL Server: Using the Database Table
Microsoft SQL Server: Table Locking
Microsoft SQL Server: Table Locking
MINISAM
Accessing Data
More than one table with the same name
DBMaker: Runtime Errors
ODBC: Runtime Errors
Multiple record formats
When Directive
Defaults used in XFD files

N

NAME
Name Directive
Name Conflict Resolution
Field names
Name Directive
Name Directive
Naming the XFD
Naming the XFD
Native SQL Errors
DBMaker: Native SQL Errors
ODBC: Native SQL Errors
New and Existing Databases Files
New and Existing Databases Files
New Data
New and Existing Databases Files
New runtime
Informix: Installing the Product
Null
Illegal COBOL Data
Date Directive
When Directive
Numeric Directive
Numeric Directive
Numeric Fields: Matching
How do I match existing numeric fields?

O

Occurs
Use Group Directive
Defaults used in XFD files
ODBC Concepts
ODBC Concepts
ODBC Information
ODBC Information
ODBC: Common Questions and Answers
ODBC: Common Questions and Answers
ODBC: Configuration File Variables
ODBC: Configuration File Variables
ODBC: Contents of the Medium
ODBC: Contents of the medium
ODBC: Data Type Mapping
ODBC: Data Type Mapping
ODBC: Designating the Host File System
ODBC: Designating the Host File System
ODBC: Driver Manager
ODBC: Designating the Host Data Source
ODBC: Driver Requirements
ODBC: Driver Requirements
ODBC: Error Messages
ODBC: Troubleshooting
ODBC: Error Retrieval
ODBC: Retrieving errors
ODBC: Getting Started
ODBC: Installation and Setup
ODBC: Installation
ODBC: Installation
ODBC: Installation and Setup
ODBC: Installation and Setup
ODBC: Installation of Acu4GL
ODBC: Installation of Acu4GL
ODBC: Installation Steps
ODBC: Installation steps
ODBC: Limits and Ranges
ODBC: Limits and Ranges
ODBC: Mapping COBOL Data Types to ODBC Data Types
ODBC: Mapping COBOL Data Types to ODBC Data Types
ODBC: Mapping ODBC Data Types to COBOL Data Types
ODBC: Mapping ODBC Data Types to COBOL Data Types
ODBC: Native SQL Errors
ODBC: Native SQL Errors
ODBC: Origins of ODBC
ODBC: Origins of ODBC
ODBC: Record Locking
ODBC: Record Locking
ODBC: Relinking Steps
ODBC: Relinking steps
ODBC: Restrictions
ODBC: Restrictions
ODBC: Retrieving Errors
ODBC: Retrieving errors
ODBC: Runtime Configuration Files
ODBC: Configuration File Variables
ODBC: Runtime Errors
ODBC: Runtime Errors
ODBC: Setting Up Data Sources
ODBC: Setting Up Data Sources
ODBC: Technical Specifications
ODBC: Technical Specifications
ODBC: User Environment
ODBC: Setting Up the User Environment
ODBC: What is ODBC?
ODBC: What is ODBC?
ODBC: Windows Control Panel
ODBC: Setting Up Data Sources
ODBC:Structure
ODBC Structure
ODBC:Troubleshooting
ODBC: Troubleshooting
On-line Document Overview: Sections
Document Overview
On-line Document: How to Use
Overview
Open Database Connectivity Information
ODBC Information
OPEN OUTPUT
Oracle: Setting Up the Search Path
OPEN OUTPUT statement: DBMaker
DBMaker: Designating the Host File System
open_cursors
Oracle: Checking System Parameters
Oracle
Oracle: Runtime Errors
Oracle Concepts Overview
Oracle Concepts Overview
Oracle Information
Acu4Gl for Oracle Information
Oracle: A-ORA-HINTS
Oracle: Configuration File Variables
Oracle: Automatic Login
Oracle: Setting Up a User Account
Oracle: Checking System Parameters
Oracle: Checking System Parameters
Oracle: COMMIT-COUNT
Oracle: Configuration File Variables
Oracle: Handling Transactions
Oracle: COMMIT-WORK
Oracle: Handling Transactions
Oracle: Common Questions and Answers
Oracle: Common Questions and Answers
Oracle: Configuration File Variables
Oracle: Configuration File Variables
Oracle: Contents of the Medium
Oracle: Contents of the Medium
Oracle: Cursor Caching
Oracle: Checking System Parameters
Oracle: Cursors
Oracle: Checking System Parameters
Oracle: Designating the Host File System
Oracle: Designating the Host File System
Oracle: Error Messages
Oracle: Runtime Errors
Oracle: Error Retrieval
Oracle: Retrieving Errors
Oracle: Execution Path
Oracle: Setting Up the User Environment
Oracle: Getting Started
Oracle: Installation and Setup
Oracle: Handling Transactions
Oracle: Handling Transactions
Oracle: Information
Acu4Gl for Oracle Information
Oracle: Installation
Oracle: Installation
Oracle: Installation and Setup
Oracle: Installation and Setup
Oracle: Installing the Product
Oracle: Installing the Product
Oracle: Installation of the Windows 95/98/NT Interface
Oracle: Installation of the Windows 95/98/NT Interface
Oracle: Limits and Ranges
Oracle: Limits and Ranges
Oracle: Linking
Oracle: Installing the Product
Oracle: MAX-CURSORS
Oracle: Configuration File Variables
Oracle: Checking System Parameters
Oracle: open_cursors
Oracle: Checking System Parameters
Oracle: ORA-LOGIN
Oracle: Setting Up the User Environment
Oracle: Configuration File Variables
Oracle: ORA-PASSWD
Oracle: Configuration File Variables
Oracle: Setting Up the User Environment
Oracle: Regarding Relinking for Windows 95/98/NT Users
Oracle: Regarding Relinking for Windows 95/98/NT Users
Oracle: Retrieving Errors
Oracle: Retrieving Errors
Oracle: Runtime Errors
Oracle: Runtime Errors
Oracle: Setting Up the Search Path
Oracle: Setting Up the Search Path
Oracle: Supported Features
Oracle: Supported Features
Oracle: Technical Specifications
Oracle: Technical Specifications
Oracle: Transaction Logging
Oracle: Handling Transactions
Oracle: Troubleshooting
Oracle: Troubleshooting
Oracle: Types Of Logins
Oracle: Setting Up a User Account
Oracle: User Account
Oracle: Setting Up a User Account
Oracle: User Environment
Oracle: Setting Up the User Environment
Oracle: USER-PATH
Oracle: Configuration File Variables
Oracle: Using the Database Table
Oracle: Using the Database Table
Oracle: File Search Path
Oracle: Setting Up the Search Path
Oracle: OPEN OUTPUT
Oracle: Setting Up the Search Path
Oracle:ORA-LOGIN
Oracle: Setting Up the Search Path
Oracle: ORA-PASSWD
Oracle: Setting Up the Search Path
Oracle: Setting Up a User Account
Oracle: Setting Up a User Account
Oracle: Setting Up the User Environment
Oracle: Setting Up the User Environment
Oracle: USER-PATH
Oracle: Setting Up the Search Path
Oracle version 8.0
Oracle version 8.0
ORA-LOGIN: Oracle
Oracle: Setting Up the User Environment
Oracle: Setting Up the Search Path
ORA-PASSWD: Oracle
Oracle: Setting Up the User Environment
Oracle: Setting Up the Search Path
Overview
Overview

P

Perfomance Guidelines
Guidelines
Performance and Troubleshooting
Performance and Troubleshooting
Performance Issues
Performance Issues
Phone Numbers
Technical Support
Preparing and Compiling Your COBOL Program
Preparing and Compiling your COBOL program

R

READ
Guidelines
READ NEXT
The WHERE Constraint
Read error on dictionary file: DBMaker
DBMaker: Runtime Errors
Redefines
Defaults used in XFD files
Relinking Steps: Informix
Informix: Installing the Product
Oracle: Installing the Product
ODBC: Relinking steps
Retrieving errors
DBMaker: Retrieving errors
Informix: Retrieving Errors
Microsoft SQL Server: Retrieving errors
ODBC: Retrieving errors
Oracle: Retrieving Errors
Sybase: Retrieving Errors
Running sql.acu from the Command Line
Running sql.acu from the command line
Runtime Configuration Files
Runtime Configuration Variables
Runtime Configuration Files
DBMaker: Configuration File Variables
Informix: Configuration File Variables
Microsoft SQL Server: Configuration File Variables
ODBC: Configuration File Variables
Oracle: Configuration File Variables
Sybase: Configuration File Variables
Runtime Configuration Variables
Runtime Configuration Variables
Runtime Errors
DBMaker: Runtime Errors
Informix: Runtime Errors
Microsoft SQL Server: Runtime Errors
ODBC: Runtime Errors
Oracle: Runtime Errors
Sybase: Runtime Errors
Runtime Options
Compiler and Runtime Options

S

SCO UNIX
 Oracle: Installing the Product
Seamless Interface
What is a Seamless Interface?
Secondary-Table Directive
Secondary-Table Directive
Security
Microsoft SQL Server
Oracle
Sybase
SELECT
Understanding How the Database Table is Formed
Naming the XFD
Using the sql.acu Program
SELECT Statement
SETPOS
ODBC
SETSTMTOPTION
ODBC
Setting the database-specific variables
Steps to Follow
Setting the files host
Steps to Follow
Setting the Parameters
Oracle: Checking System Parameters
Setting Up a User Account
Microsoft SQL Server: Setting Up a User Account
Oracle: Setting Up a User Account
Sybase: Setting Up a User Account
Setting Up Databases
DBMaker: Installation Overview
Setting Up Data Sources
ODBC: Setting Up Data Sources
Setting Up the User Environment
Microsoft SQL Server: Settung Up the User Environment
ODBC: Setting Up the User Environment
Oracle: Setting Up the User Environment
Sybase: Setting Up the User Environment
Shared libraries
DBMaker: UNIX Installation Steps for the Acu4GL for DBMaker Interface
Informix: Installing the Product
Oracle: Installing the Product
Sybase: Installation steps on the UNIX client
sql.acu
Using the sql.acu Program
sql.acu: Calling from a Program
To call sql.acu from a program
Steps to Follow
Steps to follow
Stored Procedures
Microsoft SQL Server Concepts Overview
Sybase Concepts Overview
Summary of Acu4GL
Summary
Summary of Dictionary Fields
Summary of dictionary fields
Supported Features: Informix
Informix: Supported Features
Switching File Systems: Informix
Informix: Switching File Systems
Sybase: Troubleshooting
Sybase: Troubleshooting
Sybase Concepts Overview
Sybase Concepts Overview
Sybase Information
Sybase Information
Sybase RDMS Installation
Sybase RDMS Installation
Sybase: 4GL-IGNORED-SUFFIX-LIST
Sybase: Configuration File Variables
Sybase: Acu4GL Installation
Sybase: Acu4GL Installation
Sybase: Common Questions and Answers
Sybase: Common Questions and Answers
Sybase: Configuration File Variables
Sybase: Configuration File Variables
Sybase: Contents of the Medium
Sybase: Contents of the Medium
Sybase: Designating the Host File System
Sybase: Designating the Host File System
Sybase: Error messages
Sybase: Troubleshooting
Sybase: Error Retrieval
Sybase: Retrieving Errors
Sybase: Getting Started
Sybase: Getting Started
Sybase: Installation
Sybase: Acu4GL Installation
Sybase: Installation Steps for a Windows 95 or Windows NT Client
Sybase: Installation steps for a Windows 95 or Windows NT client
Sybase: Installation Steps for a Windows NT Server Machine - UNIX Client
Sybase: Installation steps for a Windows NT server machine - UNIX Client
Sybase: Installation Steps on the UNIX Client
Sybase: Installation steps on the UNIX client
Sybase: Installation Steps on the UNIX Server
Sybase: Installation steps on the UNIX server
Sybase: Installation Steps on the UNIX Server Machine
Sybase: Installation steps on the UNIX server machine
Sybase: Installing the Diskette on the Client Machine
Sybase: Installing the Diskette on the Client Machine
Sybase: Installing the Interface for use with a UNIX Client and a UNIX or Windows NT Server
Sybase: Installing the Interface for use with a UNIX Client and a UNIX or Windows NT Server
Sybase: Installing the Interface for Use with a Windows or Windows NT Client and a UNIX or Windows NT Server
Sybase: Installing the Interface for use with a Windows or Windows NT Client and a UNIX or Windows NT Server
Sybase: Retrieving Errors
Sybase: Retrieving Errors
Sybase: Runtime Configuration Files
Sybase: Configuration File Variables
Sybase: Runtime Errors
Sybase: Runtime Errors
Sybase: Security
Sybase Concepts Overview
Sybase: Servers
Sybase Concepts Overview
Sybase: Setting Up a User Account
Sybase: Setting Up a User Account
Sybase: Setting Up the User Environment
Sybase: Setting Up the User Environment
Sybase: Stored Procedures
Sybase Concepts Overview
Sybase: Table Locking
Sybase: Table Locking
Sybase: Table Ownership
Sybase Concepts Overview
Sybase: Technical Specifications
Sybase: Technical Specifications
Sybase: Troubleshooting
Sybase: Troubleshooting
Sybase:Limits and Ranges
Sybase: Limits and Ranges
Sybase: User Account
Sybase: Setting Up a User Account
Syntax
Syntax

T

Table Locking: Microsoft SQL Server
Microsoft SQL Server: Table Locking
Sybase: Table Locking
Table Size Error
Microsoft SQL Server: Runtime Errors
Sybase: Runtime Errors
Table with Multiple Indexes
Guidelines
Technical Specifications: Microsoft SQL Server
Microsoft SQL Server: Technical Specifications
Oracle: Technical Specifications
ODBC: Technical Specifications
Sybase: Technical Specifications
Technical Support
Technical Support
Technical Tips: Informix
Informix: Technical Tips
Text Fields: Matching
How do I match existing text fields?
The ACUCOBOL-GT Plug-in and Acu4GL
The ACUCOBOL-GT Plug-in and Acu4GL
The Demonstration Program
The Demonstration Program
The WHERE Constraint
The WHERE Constraint
To call sql.acu from a Program
To call sql.acu from a program
Too many BLOBs (binary large objects)
DBMaker: Native SQL Errors
ODBC: Native SQL Errors
Too many fields in the key
DBMaker: Runtime Errors
ODBC: Runtime Errors
Trace Files (TF)
DBMaker: Retrieving errors
Microsoft SQL Server: Retrieving errors
ODBC: Retrieving errors
Transaction Logging
Informix: Common Questions and Answers
Oracle: Handling Transactions
Troubleshooting
Troubleshooting
Oracle: Troubleshooting
DBMaker: Troubleshooting
Informix: Troubleshooting
Microsoft SQL Server: Troubleshooting
ODBC: Troubleshooting
Sybase: Troubleshooting
Types of Logins: Oracle
Oracle: Setting Up a User Account

U

Understanding How the Database Table is Formed
Understanding how the database table is formed
UPDATECOLUMN:DBMaker
DBMaker: Configuration File Variables
ODBC: Configuration File Variables
Use Group Directive
Use Group Directive
User Account: DBMaker
DBMaker: Setting Up a User Account
Oracle: Setting Up a User Account
Sybase: Setting Up a User Account
User Environment: ODBC
ODBC: Setting Up the User Environment
USER-PATH
Oracle: Configuration File Variables
Oracle: Setting Up the Search Path
Using Directives
Using Directives
Using the sql.acu Program
Using the sql.acu Program

V

Variables
Configuration Variables
DBMaker
Informix
Microsoft SQL Server
ODBC
Oracle
Sybase
VAR-LENGTH
Binary Directive
Var-Length Directive
Var-Length Directive
VAX VMS
Accessing Data
Verify the link
DBMaker: Windows 95/NT Installation Steps for the Acu4GL for DBMaker Interface
DBMaker: UNIX Installation Steps for the Acu4GL for DBMaker Interface
Informix: Installing the Product
Oracle: Installing the Product
Vision File System
Runtime Configuration Variables
Vision Indexed File System
Accessing Data
Vutil
Informix: Installing the Product

W

What is a Seamless Interface?
What is a Seamless Interface?
When Directive
When Directive
WHERE Constraint
The WHERE Constraint
Windows control panel
ODBC: Setting Up Data Sources

X

-x option: DBMaker
DBMaker: Retrieving errors
XFD Files
XFD Files
XFD: Name Examples
Examples of XFD names
XFD: Naming
Naming the XFD
XFD-DIRECTORY
Runtime Configuration Variables
XFD-MAP
Runtime Configuration Variables
Naming the XFD
XFDs
Data Dictionaries

Y

Year 2000 Cutoff
Runtime Configuration Variables