1 Acu4GL Overview
1.1 Welcome to Acu4GL
1.2 Document Overview
1.3 Accessing Data
1.3 Accessing Data
1.3.1 Interface Routines
1.3.2 Data Dictionaries and Acu4GL
1.3.3 The ACUCOBOL-GT Plug-in and Acu4GL
1.4 Database Concepts
1.4 Database Concepts
1.5 How Acu4GL Works
1.5 How Acu4GL Works
1.5.1 What is a Seamless Interface?
1.5.2 Data Dictionaries and Mapping
1.5.3 Steps to Follow
1.5.4 Summary
2 Getting Started
2.1 Getting Started
2.2 Technical Support
2.3 Installation
2.4 Using the sql.acu Program
2.4 Using the sql.acu Program
2.4.1 Running sql.acu from the Command Line
2.4.2 To Call sql.acu from a Program
2.5 The Demonstration Program
2.5 The Demonstration Program
3 Data Dictionaries
3.1 Data Dictionaries or XFDs
3.2 XFD Files
3.2 XFD Files
3.2.1 Understanding How the Database Table is Formed
3.2.2 Defaults Used in XFD Files
3.2.3 Summary of Dictionary Fields
3.2.4 Identical Field Names
3.2.5 Long Field Names
3.2.6 Naming the XFD
4 Using Directives
4.1 Directives
4.2 Syntax
4.3 Alpha Directive
4.4 Binary Directive
4.5 Comment Directive
4.6 Date Directive
4.7 File Directive
4.8 Name Directive
4.9 Numeric Directive
4.10 Secondary-Table Directive
4.11 Use Group Directive
4.12 Var-Length Directive
4.13 When Directive
5 Invalid Data
5.1 Illegal COBOL Data
5.1 Illegal COBOL Data
5.1.1 Invalid Key Data
5.1.2 Invalid Data Other than Keys
5.2 Invalid Database Data
5.2 Invalid Database Data
6 Working with COBOL
6.1 Preparing and Compiling your COBOL Program
6.1 Preparing and Compiling your COBOL Program
6.1.1 Approach One
6.1.2 Approach Two
6.1.3 Approach Three
7 New and Existing Databases
7.1 Databases
7.2 Default Behavior
7.3 Existing Database Files
7.3 Existing Database Files
7.3.1 How Do I Match Existing Text Fields?
7.3.2 How Do I Match Existing Numeric Fields?
7.3.3 Field Names
7.3.4 Index Names
8 Compiler and Runtime Options
8.1 Compiler Options
8.1 Compiler Options
8.1.1 -Fx Option
8.1.2 -Zo Option
8.2 Runtime Configuration Variables
8.2 Runtime Configuration Variables
4GL-2000-CUTOFF
4GL-8-DIGIT-CUTOFF
4GL-COLUMN-CASE
4GL-CONVERT-DATES
4GL-IGNORED-SUFFIX-LIST
4GL-ILLEGAL-DATA
4GL-JULIAN-NULL
4GL-JULIAN-BASE-DATE
A4GL-COMMIT-COUNT
A4GL-MAX-DATE
A4GL-MIN-DATE
DEFAULT-HOST
filename-HOST
XFD-DIRECTORY
XFD*-MAP
XFD-MAP-RESET
9 Performance and Troubleshooting
9.1 Performance Issues
9.1 Performance Issues
9.1.1 Guidelines
9.1.2 The WHERE Constraint
9.2 Troubleshooting
9.2 Troubleshooting
9.2.1 Compile-time Errors
9.2.2 Compile-time Warning
A Acu4GL for Informix Information
A.1 Getting Started
A.1 Getting Started
A.1.1 Installation of the Acu4GL Product
A.1.2 Installing the Product
A.1.3 Designating a Database
A.2 Configuration File Variables
A.2 Configuration File Variables
A-INF-DUPLICATE-KEY
A-INF-NO-FINAL-TRANSACTION-ERROR
A-INFORMIX-ERROR-FILE
DATABASE
INF-LOGIN
INF-PASSWD
MAX-CURSORS
A.3 Technical Information, Troubleshooting, and Common Questions and Answers
A.3 Technical Information, Troubleshooting, and Common Questions and Answers
A.4 Supported Features
A.4 Supported Features
A.5 Limits and Ranges
A.5 Limits and Ranges
A.6 Troubleshooting
A.6 Troubleshooting
A.6.1 Runtime Errors
A.6.2 Retrieving Errors
A.7 Informix 7.2 and 7.3 Performance
A.7 Informix 7.2 and 7.3 Performance
A.8 Common Questions and Answers
A.8 Common Questions and Answers
B Acu4GL for Microsoft SQL Server Information
B.1 Microsoft SQL Server Concepts Overview
B.2 Getting Started
B.2 Getting Started
B.2.1 Installation and Setup
B.2.2 Installing the Acu4GL Product on a Client Machine
B.2.3 Setting Up a User Account
B.2.4 Setting Up the User Environment
B.2.5 Designating the Host File System
B.3 Configuration File Variables
B.3 Configuration File Variables
A-MSSQL-ADD-IDENTITY
A-MSSQL-ADD-TIMESTAMP
A_MSSQL_CURSOR_OPTION_1 A_MSSQL_CURSOR_OPTION_2 A_MSSQL_CURSOR_OPTION_3
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-COUNT-CHECK
A-MSSQL-NO-DBCLOSE
A-MSSQL-NO-DBID
A-MSSQL-NO-RECORD-LOCKS
A-MSSQL-NO-TABLE-LOCKS
A-MSSQL-NO-23-ON-START
A-MSSQL-PACKETSIZE
A-MSSQL-PASSWD
A-MSSQL-ROWCOUNT
A-MSSQL-SKIP-ALTERNATE-KEYS
A-MSSQL-USE-DROPDOWN-QUERIES
A-MSSQL-UNLOCK-ON-EXECUTE
A-MSSQL-VISION-LOCKS-FILE
B.4 Microsoft SQL Server: Using the Database Table
B.4 Microsoft SQL Server: Using the Database Table
B.5 Technical Information, Troubleshooting, and Common Questions and Answers
B.5 Technical Information, Troubleshooting, and Common Questions and Answers
B.5.1 Technical Specifications
B.5.2 Stored procedures
B.6 Limits and Ranges
B.6 Limits and Ranges
B.7 Troubleshooting
B.7 Troubleshooting
B.7.1 Runtime Errors
B.7.2 Retrieving errors
B.8 Common Questions and Answers
B.8 Common Questions and Answers
C Acu4GL for Oracle Information
C.1 Oracle Concepts Overview
C.2 Installation and Setup
C.2 Installation and Setup
C.2.1 Windows Installation Steps for the Acu4GL for Oracle Product
C.2.1 Windows Installation Steps for the Acu4GL for Oracle Product
Regarding Relinking for Windows Users
C.2.2 UNIX Installation Steps for the Oracle Acu4GL Product
C.2.2 UNIX Installation Steps for the Oracle Acu4GL Product
C.2.3 Installing the Product
C.2.3 Installing the Product
C.2.4 Checking System Parameters
C.2.4 Checking System Parameters
C.2.5 Setting Up a User Account
C.2.5 Setting Up a User Account
C.2.6 Setting Up the User Environment
C.2.6 Setting Up the User Environment
C.2.7 Designating the Host File System
C.2.7 Designating the Host File System
C.2.8 Setting Up the Search Path
C.2.8 Setting Up the Search Path
C.2.9 Handling Transactions
C.2.9 Handling Transactions
C.3 Configuration File Variables
C.3 Configuration File Variables
A-ORA-DUPLICATE-KEY
A-ORACLE-ERROR-FILE
A-ORA-HINTS
COMMIT-COUNT
MAX-CURSORS
ORA-LOGIN
ORA-PASSWD
USE-INVALID-CURSOR-LOGIC
USER-PATH
C.4 Using the Database Table
C.4 Using the Database Table
C.5 Technical Information, Troubleshooting, and Common Questions and Answers
C.5 Technical Information, Troubleshooting, and Common Questions and Answers
C.5.1 Supported Features
C.5.2 Limits and Ranges
C.6 Troubleshooting
C.6 Troubleshooting
C.6.1 Runtime Errors
C.6.2 Retrieving Errors
C.6.3 Common Questions and Answers
D Acu4GL for ODBC Information
D.1 ODBC Concepts
D.1 ODBC Concepts
D.1.1 What is ODBC?
D.1.2 Origins of ODBC
D.1.3 Restrictions
D.1.4 ODBC Structure
D.2 Installation and Setup
D.2 Installation and Setup
D.2.1 Installation
D.2.2 Installation of Acu4GL
D.2.3 Setting up Data Sources
D.2.4 Setting up the User Environment
D.2.5 Designating the Host File System
D.2.6 Designating the Host Data Source
D.3 Configuration File Variables
D.3 Configuration File Variables
A4GL-MAX-DATE
A4GL-MIN-DATE
A-ODBC-COMMIT-ON-BEGIN
A-ODBC-DATASOURCE
A-ODBC-ERROR-MAP-FILE
A-ODBC-LOCK-METHOD
A-ODBC-LOGIN
A-ODBC-NO-NULL-COLUMNS
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
D.4 Technical Information, Troubleshooting, and Common Questions and Answers
D.4 Technical Information, Troubleshooting, and Common Questions and Answers
D.4.1 Record and Table Locking
D.4.2 Limits and Ranges
D.4.3 Driver Requirements
D.4.4 Data Type Mapping
D.5 Troubleshooting
D.5 Troubleshooting
D.5.1 Runtime Errors
D.5.2 Retrieving Errors
D.5.3 Native SQL Errors
D.6 Common Questions and Answers
D.6 Common Questions and Answers
E Acu4GL for Sybase Information
E.1 Sybase Concepts Overview
E.2 Getting Started
E.2 Getting Started
E.2.1 Sybase RDBMS Installation
E.3 Acu4GL for Sybase Installation
E.3 Acu4GL for Sybase Installation
E.3.1 Installing the Product for Use with a UNIX Client and a UNIX or Windows
NT Server
E.3.2 Installation Steps on the UNIX Client
E.3.3 Installation Steps on the UNIX or Windows NT Server
E.3.4 Installing the Product for Use with a Windows Client and a UNIX or
Windows NT Server
E.3.5 Installation Steps on the UNIX Server Machine
E.3.6 Installation Steps on a Windows NT Server Machine - Windows Client
E.3.7 Installation Steps for a Windows Client
E.4 Setup, Variables, and Technical Information
E.4 Setup, Variables, and Technical Information
E.4.1 Setting up a User Account
E.4.2 Setting up the User Environment
E.4.3 Designating the Host File System
E.5 Configuration File Variables
E.5 Configuration File Variables
A-SYB-ADD-IDENTITY
A-SYB-ADD-TIMESTAMP
A-SYB-CURSOR-OPTION-1 A-SYB-CURSOR-OPTION-2 A-SYB-CURSOR-OPTION-3
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-COUNT-CHECK
A-SYB-NO-DBCLOSE
A-SYB-NO-DBID
A-SYB-NO-RECORD-LOCKS
A-SYB-NO-TABLE-LOCKS
A-SYB-NO-23-ON-START
A-SYB-PACKETSIZE
A-SYB-PASSWD
A-SYB-ROWCOUNT
A-SYB-SKIP-ALTERNATE-KEYS
A-SYB-USE-DROPDOWN-QUERIES
A-SYB-UNLOCK-ON-EXECUTE
A-SYB-VISION-LOCKS-FILE
E.6 Technical Specifications
E.6 Technical Specifications
E.6.1 Record and Table Locking
E.6.2 Stored procedures
E.6.3 Limits and Ranges
E.7 Troubleshooting
E.7 Troubleshooting
E.7.1 Runtime Errors
E.7.2 Retrieving Errors
E.7.3 Common Questions and Answers
F Acu4GL for DBMaker Information
F.1 DBMaker Concepts Overview
F.1 DBMaker Concepts Overview
F.1.1 What is DBMaker?
F.1.2 DBMaker Structure
F.1.3 DBMaker and Acu4GL Architecture
F.2 Installation and Setup for Windows and UNIX
F.2 Installation and Setup for Windows and UNIX
F.2.1 Installation Overview
F.2.2 Windows Installation Steps for the Acu4GL for DBMaker Product
F.2.3 UNIX Installation Steps for the Acu4GL for DBMaker Product
F.2.4 Setting up a User Account
F.2.5 Designating the Host File System
F.2.6 Designating the Host Database
F.3 Configuration File Variables
F.3 Configuration File Variables
A-DBM-COMMIT-ON-BEGIN
A-DBM-DATABASE
A-DBM-ERROR-MAP-FILE
A-DBM-LOCK-METHOD
A-DBM-LOGIN
A-DBM-NO-NULL-COLUMNS
A-DBM-PASSWD
A-DBM-QUOTE-IDENTIFIERS
A-DBM-UNSIGNED-TINYINT
A-DBM-USE-CHAR-FOR-BINARY
A-DBM-USE-SPACE-IN-DATES
F.4 Technical Information, Troubleshooting, and Common Questions and Answers
F.4 Technical Information, Troubleshooting, and Common Questions and Answers
F.4.1 Record and Table Locking
F.4.2 Limits and Ranges
F.4.3 Data Type Mapping
F.5 Troubleshooting
F.5 Troubleshooting
F.5.1 Runtime Errors
F.5.2 Retrieving Errors
F.5.3 Native SQL Errors
F.6 Common Questions and Answers
F.6 Common Questions and Answers
Glossary of Terms
Glossary of Terms
(c) Copyright Acucorp, Inc., 1991-2000. ALL RIGHTS RESERVED.